Page 1 of 1

Search with excluding categories

Posted: Sun Apr 30, 2017 6:18 pm
by Nimrodel
Hello!

Recently I saw a topic in the forum XnView Classic with someone posting exactly the same question I was asking myself: http://newsgroup.xnview.com/viewtopic.php?f=35&t=24822. Unfortunately there was no answer, so I post it here in MP quoting the question and hoping there will be an answer :wink:

"It would really be a great feature if there was a possibility to exclude some categories.
Ideally it would be just magical if user could construct his own searches with categories. Like you would like to find all pictures with keyword vacation that also include keywords for your wife or daughter but not with the beach keyword. That would make you cooler than ACDSee and Adobe Bridge.
Is it hard to implement? Shouldn't that be one of basic SQL features since XnView MP uses databases to store data?
"

Re: Search with excluding categories

Posted: Mon May 01, 2017 7:12 am
by m.Th.
It can be implemented - basically the two trees with categories (the one used for finding and assignment in Categories Pane AND the one used for filtering) should be merged and at the end of the newly created tree should be added a tree-state checkbox. The states are:

- checked: IN (included)
- not checked: NOT IN (excluded)
- grayed: - doesn't matter -

From SQL point of view the query can be constructed very simple by having the correspondent IN (myCatID1, myCatID2, myCatID3,...) and similar NOT IN clause. In fact it is more a string processing task which will build the SQL WHERE which will be passed to the DB. Details available for Pierre upon request.

Yep, of course it would be cooler than ACDSee and Bridge. ...and Lightroom (which is very slow on large datasets).

Already added in tracker here: http://www.xnview.com/mantisbt/view.php?id=389

We hope that we'll see it in the new version. :D It is a very important and requested feature.

Re: Search with excluding categories

Posted: Sun May 14, 2017 1:33 pm
by Nimrodel
Thanks for the answer, good to know that this is on the to-do list :)

Re: Search with excluding categories

Posted: Sun May 14, 2017 1:37 pm
by bdragon
:D

Re: Search with excluding categories

Posted: Sat Jan 05, 2019 5:52 pm
by limar500
hi, is there any update on this? I'm interested in this too

Re: Search with excluding categories

Posted: Mon Jan 07, 2019 9:57 am
by xnview
m.Th. wrote:
Mon May 01, 2017 7:12 am
- checked: IN (included)
- not checked: NOT IN (excluded)
- grayed: - doesn't matter -
so a 3-states checkbox?

Re: Search with excluding categories

Posted: Wed Jan 09, 2019 5:49 pm
by m.Th.
xnview wrote:
Mon Jan 07, 2019 9:57 am
m.Th. wrote:
Mon May 01, 2017 7:12 am
- checked: IN (included)
- not checked: NOT IN (excluded)
- grayed: - doesn't matter -
so a 3-states checkbox?
Yes. This is the standard behavior in any such filtering engine. For the checked ones you will gather the IDs / PK (primary keys) put comma between them and add them in a SQL IN predicate. For the unchecked ones do the same but put the comma delimited PK values in a SQL NOT IN predicate in the WHERE clause.

Re: Search with excluding categories

Posted: Wed Jan 09, 2019 5:51 pm
by m.Th.
...of course, by default the 3-state checkbox will be 'Grayed' by default.

Re: Search with excluding categories

Posted: Thu Jan 10, 2019 8:49 am
by m.Th.
...also don't forget to test the "Match" drop-down for "Any" and "All" predicates (that is AND and OR) in the case of the tri-state checkbox.

Re: Search with excluding categories

Posted: Thu Jan 10, 2019 4:23 pm
by xnview
m.Th. wrote:
Wed Jan 09, 2019 5:51 pm
...of course, by default the 3-state checkbox will be 'Grayed' by default.
not too complicated for standard user??

Re: Search with excluding categories

Posted: Wed Jan 16, 2019 10:29 am
by m.Th.
xnview wrote:
Thu Jan 10, 2019 4:23 pm
m.Th. wrote:
Wed Jan 09, 2019 5:51 pm
...of course, by default the 3-state checkbox will be 'Grayed' by default.
not too complicated for standard user??
Nope. We use this paradigm in our programs which are used by VERY standard users (or even worse - no offense intended, some of the users of the programs which we make (develop) see the program as their very first experience on a computer, before learning Windows, Folders hierarchy, keyboard, File Open / Save etc. - basic things in computer usage). They find "Checked" "Empty = Unchecked" and "Grayed" paradigm very natural for "Yes", "No" and ...well "Grayed" = Undefined / Doesn't matter.

Re: Search with excluding categories

Posted: Sat May 11, 2019 7:31 pm
by heavyvoidx
imho, this function is vital when searching through thousands of photos... can you say, please, whats the progress on it?

Re: Search with excluding categories

Posted: Mon May 13, 2019 8:39 am
by heavyvoidx
xnview wrote:
Thu Jan 10, 2019 4:23 pm
m.Th. wrote:
Wed Jan 09, 2019 5:51 pm
...of course, by default the 3-state checkbox will be 'Grayed' by default.
not too complicated for standard user??
As the question is opened for years already, and the most problem is GUI changes:

Maybe the function can be implemented faster, without changing GUI (for the first time), by search text-field, where the user can manually write IN "tag 1" AND IN "tag 2" AND NOT IN "tag 3" ?

Re: Search with excluding categories

Posted: Mon May 20, 2019 5:57 am
by m.Th.
heavyvoidx wrote:
Mon May 13, 2019 8:39 am
xnview wrote:
Thu Jan 10, 2019 4:23 pm
m.Th. wrote:
Wed Jan 09, 2019 5:51 pm
...of course, by default the 3-state checkbox will be 'Grayed' by default.
not too complicated for standard user??
As the question is opened for years already, and the most problem is GUI changes:

Maybe the function can be implemented faster, without changing GUI (for the first time), by search text-field, where the user can manually write IN "tag 1" AND IN "tag 2" AND NOT IN "tag 3" ?
To quote Pierre: I think that this is "too complicated for the user" :) - I would say that it isn't discoverable. The user doesn't know that such a possibility exists and also, implementing a parser most probably is more difficult than adding some checkboxes to GUI.