How to query a list of keywods using AND Operator

Working with a content view.

I am looking to offer the user the capability to perform a search on multiple keywords with AND operator

For instance : keyword1 : 'tag1' keyword2: 'tag2' keyword3: 'tag3'

=> SELECT * FROM Document WHERE app_com:keywords = 'tag1' AND edoc_com:keywords = 'tag2' AND edoc_com:keywords = 'tag3'

What kind of widget could help me to achieve this?

So far i did use List widget but it workds with IN operator

Any help appreciated.


0 votes

0 answers