distal-attribute
distal-attribute
distal-attribute
distal-attribute

Database filter using multiple sessions

energiesysteme posted 3 years ago in Feature discussion
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
ansgar posted 3 years ago
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.
energiesysteme posted 3 years ago
Why do it simple when you can do it complex?smile

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... wink
ansgar posted 3 years ago
That means now ...?
energiesysteme posted 3 years ago
Sorry I didn't understand what you mean.

energiesysteme posted 3 years ago
Sorry I don't understand what you mean.
ansgar posted 3 years ago
I'm asking for practical ideas which conclude from your rhetorical question "Why do it simple when you can do it complex?".
energiesysteme posted 3 years ago
It was a jokesmile

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.
ansgar posted 3 years ago
Yes, I got that. But I did not get what you exactly propose in order to make that filter stuff more easy to use?
energiesysteme posted 3 years ago
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.

ansgar posted 3 years ago
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.
energiesysteme posted 3 years ago
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.
ansgar posted 3 years ago
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.

Please login to leave a reply, or register at first.