search

yy0931 / sqlite3-editor

https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor
GNU General Public License v3.0
1k stars 7 forks source link

Additional column filter options #47

Closed fofiddy closed 10 months ago

fofiddy commented 10 months ago

It would be helpful to have more column filtering options. See Excel for examples. Greater than, less than, ranges, etc. for integers. Null/Not null values, Present a list of distinct values for checkbox selection, etc. Refer to Excel column filtering options for expansive examples.

Nice work!

yy0931 commented 10 months ago

Thanks. I'll implement it when I have time, although the priority is low since this can be done using SELECT statements in the query editor.

yy0931 commented 10 months ago

I've added a button for specifying arbitrary SQL expressions for column filters. This may not be user-friendly for those new to SQL, so I'm considering adding buttons to initialize SQL expressions for basic operations such as <, >, etc., in later versions.

image

yy0931 commented 10 months ago

I forgot to mention that the Group by Value feature can be seen as "a list of distinct values for checkbox selection."