Quick filter from column's unique values list


I moved recently from Oracle SQL Developer to DataGrip and I'm very happy with the choice I've made as DataGrip is way better than SQL Developer. However, there is one feature from SQL Developer I greatly miss in DataGrip, which is to create a filter by choosing a column value from a list compiled of all distinct values for that column. In other words, the UI executes "SELECT DISTINCT <column>" and shows the returned values in a list for the user to choose from and set the filter. As a side benefit, the feature would answer a very common question "what are all (distinct) values stored in this column". If the values list had a "count" (number of occurrences) next to each value, it would be even better. I have included a screenshot of this feature in SQL Developer. Thank you.

1 comment

Here is [feature request](https://youtrack.jetbrains.com/issue/DBE-339), please follow and vote to get noticed on any updates


Please sign in to leave a comment.