[1280] Advanced Search choice list is not complete

[kalain]

Hi,

 

Here is a screen copy of advanced search (with keyword as example)

 

Now from keyword list, if you 'Alt+clic' on "920" keyword

You have this :

 

Which is 'do not content '920'

 

Now, in advanced search list choice, a new choice appear : 'not equals'

 

why not to propose this choice 'Not equals' in advanced search window ?

 

Seems there is some things to fix here ?

 

Regards

[petrovich]

Hi, kalain!

 

When you select this query from keyword list ('Alt+clic' on "920" keyword), we know id (unique identifier) for this keyword, and we use it in database query.

 

In advanced search window you operate with content of keyword (not with id). And 'Not equals' query in this case significantly more sophisticated (especially in consideration of synonyms for keywords).

 

Formally, these two queries are not equivalent and may give different results.

[kalain]

Ok but why in advanced search I couldn't make a query like : Keywords does not contains '920'

In SQL language this could looks like : WHERE (Table.keyword Not Like '*' & "920" & '*'

(Works well in Access database)

 

NB : 920 is not linked at any tag. This is user which write contents which he does not want to see.

 

Something like :

[petrovich]

Ok but why in advanced search I couldn't make a query like : Keywords does not contains '920'

In SQL language this could looks like : WHERE (Table.keyword Not Like '*' & "920" & '*'

(Works well in Access database)

 

This method not will work for many-to-many relationship (keywords as example), because show you wrong result.

 

But anyway, we will discuss include 'not equals' in advanced search on our meeting.

[kalain]

a bit strange that you can not exclude "920" from any tag in advanced search window.

 

By now, the only way to do this is using Alt key pressed and then clic on "920" keyword. (which is 920)

[Sylvain M.]

I was looking for a "does not contain" search in Daminion, but I did not succeed.

So I add my interest in this feature that should not be so complicated in SQL.

 

Thank you to the development team! :wink:

 

Sylvain M.