Select Statements - WHERE clause value suggestion
I would like to get suggestions for the WHERE query value. For example, when querying a dimension table, I would like to receive a selection box with the possible values to enter.
empid firstname lastname
1 Test User
2 Dummy User
Select * from Table
Where firstname= [Suggestion Box displays the values "Test" and "Dummy" to pick]
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.
The Prompt Team
1) suggestions for all database tables would be great!
2) the first top 100 lines shall be sufficient, the sort order should be configurable.
3) the usage scenario is to query on a dimensional data modell ->I want to be able to filter faster in a star schema