Table filtering

Feature requests and their debate

Table filtering

Postby your-mirror » Thu Oct 08, 2015 7:25 am

Hello, thank you for your project!!!
Will be amazing add table/database filtering and "my favorites table" like in HeidiSQL.

Look at screenshot...
Attachments
imgo.jpeg
imgo.jpeg (12.42 KiB) Viewed 30277 times
your-mirror
 
Posts: 3
Joined: Fri Sep 25, 2015 7:34 am

Re: Table filtering

Postby Serge » Thu Oct 08, 2015 7:48 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Table filtering

Postby your-mirror » Fri Oct 09, 2015 12:08 pm

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...
your-mirror
 
Posts: 3
Joined: Fri Sep 25, 2015 7:34 am

Re: Table filtering

Postby Serge » Fri Oct 09, 2015 3:10 pm

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?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Table filtering

Postby your-mirror » Tue Oct 13, 2015 6:43 am

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.
your-mirror
 
Posts: 3
Joined: Fri Sep 25, 2015 7:34 am

Re: Table filtering

Postby halmai » Mon Feb 08, 2016 3:02 am

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.
halmai
 
Posts: 1
Joined: Mon Feb 08, 2016 2:50 am


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 2 guests