Filter by drop-down menus on each column

Features wanted...
Geoffrey
Posts: 12
Joined: 13 Sep 2021 13:51

Filter by drop-down menus on each column

Post by Geoffrey »

The ideal would be to be able to filter files via an elaborate filter with drop-down menus on each column.

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

For example?

Geoffrey
Posts: 12
Joined: 13 Sep 2021 13:51

Re: Filter by drop-down menus on each column

Post by Geoffrey »

For example, select only "24V" for "Critère 2" and "1 pompe" for "Critère 3".

Is it possible in the filter with text formule but it will be the top if it would be possible directly by one click of th mouse.
Attachments
Example.PNG
Example.PNG (31.56 KiB) Viewed 4844 times

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

You mean a right-click into this cell will pop a menu with a command to filter the list by "Critère 3: 1 pompe"?
Example (1)b.PNG
Example (1)b.PNG (33.25 KiB) Viewed 4840 times
Probably not a bad idea... :tup:

xy123
Posts: 141
Joined: 17 Sep 2017 11:46

Re: Filter by drop-down menus on each column

Post by xy123 »

He is probably talking about Windows Explorer feature:

Image

It's dynamic, ie. in "Date modified" there wouldn't be "Today" if I haven't made that zNew file.
Also there is that very useful "Search again in: Subfolders" after you select some filter.
I'm on Win7 so you should check on Win10 if they have improved it further.

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

It's a cool feature, but obviously it would be a major effort to add it. I'll keep it in my mind for later.

BTW, XY's filter architecture (Visual as well as Live filters) currently only supports certain file properties but not all columns, especially not Custom Columns. So currently there is no way at all to filter a list by these columns. You can however search a location by Custom Column contents which is *kind* of a filter.

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

Well, I changed XY's filter architecture (3 days in the code mine), and now it should work: Ctrl+Right-Click the cell you are interested in and click "Set as Live Filter". Now the list only shows items with the same value in that column.

jupe
Posts: 2749
Joined: 20 Oct 2017 21:14
Location: Win10 22H2 120dpi

Re: Filter by drop-down menus on each column

Post by jupe »

Just as an FYI, this doesn't seem to work in the "Type" column. (using the prop selector to do it works though still), also is it supposed to work for Special Property columns eg. "Tag Artist" ? from the changelog I get the impression it is, but just wanted confirmation, because strangely for me it works for some special properties eg. "Dimensions", but not others (like any of the audio specific ones, which do now work via QSrch using the new selectors though), hence the question.

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

Yes, all confirmed. Should be fixed in v22.20.0214.

jupe
Posts: 2749
Joined: 20 Oct 2017 21:14
Location: Win10 22H2 120dpi

Re: Filter by drop-down menus on each column

Post by jupe »

While testing I noticed that when using the column name selectors, "Frame width", "Frame height", "ISO Speed", "Camera Model", "Bit Depth" and "Date Taken" they don't seem to work via LF still, but everything else seems too so far. Also if I accidentally input a "[" char within the selector prefix in the livefilter, I get a couple error 93 invalid pattern string ladybug dialogs.
I can foresee this new feature being very handy, nice work. :beer:

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

Again, all confirmed. Should be fixed in v22.20.0217.

Geoffrey
Posts: 12
Joined: 13 Sep 2021 13:51

Re: Filter by drop-down menus on each column

Post by Geoffrey »

Hello,

Yes, what i think is near of the post of XY123.

For Ctrl+Right click, i'll test this .

Thank you.

jupe
Posts: 2749
Joined: 20 Oct 2017 21:14
Location: Win10 22H2 120dpi

Re: Filter by drop-down menus on each column

Post by jupe »

What do you think about a shift click to invert the filter?, and maybe Ctrl+Shift to boolean AND it with the current LF (if there is one) instead of replace it?

Horst
Posts: 1080
Joined: 24 Jan 2021 12:27
Location: Germany

Re: Filter by drop-down menus on each column

Post by Horst »

jupe wrote: 23 Sep 2021 01:51 What do you think about a shift click to invert the filter?, and maybe Ctrl+Shift to boolean AND it with the current LF (if there is one) instead of replace it?
Good suggestion.
The only problem is that all this shortcuts have to be find or remebered.
Adidional entries in the View menu which also show the shortcuts may help.
Windows 11 Home x64 Version 23H2 (OS Build 22631.3235)
Portable XYplorer (actual version, including betas)
Everything 1.5.0.1371a (x64), Everything Toolbar 1.3.2, Listary Pro 6.3.0.69

admin
Site Admin
Posts: 60289
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Filter by drop-down menus on each column

Post by admin »

Yeah, that's good. :tup:

But invert (= prefixed !) needs this to be checked: Configuration | Find and Filter | Filters & Type Ahead Find | Live Filter Box | Enable extended pattern matching
So the invert functionality would only be available if "Enable extended pattern matching" is enabled, otherwise the action would trigger nothing. Hence I would rather add "Invert" to the context menu of the Information Bar (disabled if not available).

[Ctrl]+Shift to boolean AND looks perfect to me. (The necessity of Ctrl depends on that other setting: Hold Ctrl to show cell context menu)
Rubbish. Of course, you meant Shift *after* the menu has popped.
Then we could do:
Shift for boolean AND
Ctrl for boolean OR
or vice versa, not sure

Post Reply