Page 1 of 1

Table filtering

PostPosted: Thu Oct 08, 2015 7:25 am
by your-mirror
Hello, thank you for your project!!!
Will be amazing add table/database filtering and "my favorites table" like in HeidiSQL.

Look at screenshot...

Re: Table filtering

PostPosted: Thu Oct 08, 2015 7:48 am
by Serge
These features are already there.
Database/table filters can be set in connection editor dialog (tab "General") or you can just right click on a folder element (e.g. "Tables") in database navigator and choose "Filter ..." in the context menu.
Favorites are bookmarks. Select an element and press ctrl+d.

Re: Table filtering

PostPosted: Fri Oct 09, 2015 12:08 pm
by your-mirror
I mean filtering on the fly, when I have typing. For example show all tables that contain name like "list_". At this moment filter work with full name of table...

Re: Table filtering

PostPosted: Fri Oct 09, 2015 3:10 pm
by Serge
You can use masks in filters (% and _).
Also you can open table list (double click on "Tables") and search there (ctrl+f).

Agreed, that's not exactly the same function as in Heidi. But I'm not sure that adding yet another search/filter function makes sense. To be honest I don't understand how this global filter on the top panel should work. Filter tables in all databases? What if you have many open connections to a different databases?

Re: Table filtering

PostPosted: Tue Oct 13, 2015 6:43 am
by your-mirror
What about filter for connections/db/tables ? :)
Some times I need to find a table with a specific name (prefix) and in my opinion it's fastest and simplest way to find the table.

Re: Table filtering

PostPosted: Mon Feb 08, 2016 3:02 am
by halmai
First of all, I also want to say thanks for DBeaver.

Next, I agree with this topic, the table filter combo box is amazing in HeidiSQL. I have to work with a database having more than 150 tables. There are many of them with pretty similar names. In HeidiSQL it is easy to click the bottom of the list, modify the regexp in the combo box from "log_*|message_*" to "*client*" and it filters the list of the tables while I type. I mean, it updates the list as soon as the content of the combo box is a valid regexp. It makes the filtering pretty quick, especially if I can pick one of the earlier regexps from the history of this combo box.

The present solution in Dbeaver works, I don't debate it, but it is far less user friendly and far less convenient. If this is a matter of votes then I vote for adding this feature. :)

Thanks.