Database filter using multiple sessions

Hello,

Is it possible to have the database filter customized per session?

When I work on the project #1, I mainly use the database filter "filter1".
When I work on the project #2, I mainly use the database filter "filter2".
That's normal; by definition filters depend on the project loaded!
For the moment, I always have to switch my database filter after logged in.

I think a database filter history per session would be very efficient!

Thank you,
Have a good new year day!

Anthony

The session manager has a per-session database filter which you can use. This is a simple semicolon separated list.

The filter below the tree is intentionally global, not per session.

If you want a session based filter you can only use the first one. I guess it could be problematic that this does not support regular expressions, maybe I can implement such logic here in the future.

Why do it simple when you can do it complex?

The semicolon separated list is very convenient for a session, but if you use it also for the multi session, it quickly become unreadable.

I manage 2 projects with 1900 and 900 databases and 6 others projects with about 30 db each.
Just imagine the non multi session semicolon separated list I have to use...

That means now ...?

Sorry I didn't understand what you mean.

Sorry I don't understand what you mean.

I'm asking for practical ideas which conclude from your rhetorical question "Why do it simple when you can do it complex?".

It was a joke

What I meant was that because of the number of databases in my projects, it is very difficult to use the same semicolon separated list for all my sessions.

Yes, I got that. But I did not get what you exactly propose in order to make that filter stuff more easy to use?

Hello,

Please find screenshots here (link available 4 days from now) :

http://demo.ovh.com/fr/ac14a3fd31c3518c9620c4f6a7ecada4/

Now.jpg
There are 2 projects :
- "Prod - SQL Maitre"
- "Prod - Testing"

The common filter is "infor" which display "information_schema" in both projects.

Idea 1 : Idea1.jpg
To change the content of the filter when we change the current project.
Now, when we change the current project, you dim the others projects.
Maybe you can replace the content of the filter textbox depending on the current project.

Idea 2 : Idea2.jpg
To use tabs for the different projects which contain the databases tree and the filter.

I think the #2 is the best because it is very easy to switch from a project to another one and the filter textbox is visibly linked to the session.

If needed, I can explain more.

I won't add tabs above the tree, so maybe the regex filter should change when focus changes, which may be a slightly implicit, magical approach, GUI wise. Hm. Give me some time to overthink that.

You don't like my tab picture? :)

Ok, thanks you for think about it and maybe one day I will see it in a release.

Tabs are in use all over the place. And tabs hide their contents untils they are activated. Especially the tree can easily display more than one root node, so I prefer not to have tabs here. Well, I'll think of the other idea.