Jump to content

[1280] Advanced Search choice list is not complete


kalain
 Share

Recommended Posts

Hi,

 

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

post-891-0-40430700-1450034407_thumb.jpg

 

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

You have this :

post-891-0-20642600-1450034523_thumb.jpg

 

post-891-0-61189700-1450034546_thumb.jpg

Which is 'do not content '920'

 

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

post-891-0-28577800-1450034593_thumb.jpg

 

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

 

Seems there is some things to fix here ?

 

Regards

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 :

post-891-0-57419400-1450077313_thumb.jpg

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 3 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...