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.