Search with excluding categories
Moderators: XnTriq, helmut, xnview, Dreamer
Search with excluding categories
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
"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?"
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
"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
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. It is a very important and requested feature.
- 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. It is a very important and requested feature.
m. Th.
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
Re: Search with excluding categories
Thanks for the answer, good to know that this is on the to-do list
Re: Search with excluding categories
hi, is there any update on this? I'm interested in this too
Re: Search with excluding categories
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.
m. Th.
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
Re: Search with excluding categories
...of course, by default the 3-state checkbox will be 'Grayed' by default.
m. Th.
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
Re: Search with excluding categories
...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.
m. Th.
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
Re: Search with excluding categories
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.
m. Th.
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
-
- Posts: 2
- Joined: Thu May 09, 2019 7:53 pm
Re: Search with excluding categories
imho, this function is vital when searching through thousands of photos... can you say, please, whats the progress on it?
-
- Posts: 2
- Joined: Thu May 09, 2019 7:53 pm
Re: Search with excluding categories
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
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.heavyvoidx wrote: ↑Mon May 13, 2019 8:39 amAs 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" ?
m. Th.
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.6 64bit on Win11 x64 -
Re: Search with excluding categories
add an exclusion/blacklist option, for example to search for all images but selected couple of formats