dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.33k stars 3.4k forks source link

DB Full-Text search - Enhance table filtering/selection #22448

Open jathri opened 8 months ago

jathri commented 8 months ago

Is your feature request related to a problem? Please describe. I'm always frustrated when I need to multiselect (using SHIFT) 6500 tables and then manually unselect (using CTRL) 600 tables since these are t(e)mp tables that I want to be omitted from search.

Describe the solution you'd like Consider improving UI here: https://i.imgur.com/nOdWYx5.png At least adding (regex?) filter that allows user to omit tables starting with t(e)mp or whatever string would be OK. Possibly activated by right clicking Tables and then working in some separated gui.

Describe alternatives you've considered Consider implementing more general table selecting/filtering solution for tables since CTRL and single table clicking (or even multiselecting using SHIFT) is really no way.

Note: it would also be useful if user could save filters/selections for repeated use. This is possibly somewhat similar request to https://github.com/dbeaver/dbeaver/issues/21905.

LonwoLonwo commented 8 months ago

Hello @jathri

Thanks for the idea.

As a workaround for now - you can copy your connection, and in the connection settings of your copied connection, add a table filter. And then use search in this copied filtred connection.

2024-01-15 11_11_09-Connection _TEST_DB 1_ configuration

jathri commented 8 months ago

I would not even call this a workaround. It is good enough solution for this particular use case. Thank you.