Forums: [SOLVED] all conditions over same field (Search question) - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

[SOLVED] all conditions over same field (Search question) Rate Topic: -----

#1 User is offline   Michael2 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 31
  • Joined: 10-April 18

Posted 11 February 2019 - 11:35 PM

You can add the same search field >1 time in the search panel.

Question: is it possible to use this to do a search "contains TermA AND contains TermB" ?
In my tests it always does an any (OR) search in this scenario, independently on the selection in the dropdown (any condition / all conditions).

In other words: a query of the form (pseudo-SQL): SELECT....WHERE searchField like "%foo%" AND searchField like "%bar%"
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 16322
  • Joined: 03-February 03
  • Gender:Male

Posted 13 February 2019 - 04:06 PM

This can be done, with the help of Search API. You can use setSearchSQL function from Search API for this purpose:
https://xlinesoft.co..._search_sql.htm
Best regards,
Sergey Kornilov
0

#3 User is offline   Michael2 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 31
  • Joined: 10-April 18

Posted 15 February 2019 - 06:03 PM

Thanks, I'll have a look at it.
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users