Forum Discussion

Yulia-Anaplan's avatar
Yulia-Anaplan
Guide
4 years ago

Liql query with OR/AND

Hi, I am trying to create a query that will pull articles with specific labels. For example, I'd like to show only articles that have labels 'Cats' or 'Dogs' or 'Birds' or any different combinati...
  • SuzieH's avatar
    SuzieH
    4 years ago

    Hi Yulia-Anaplan. OR has a fairly limited use within LiQL. As you saw earlier, OR will act as an AND in the use case you tried. Generally, OR is supported in conjunction with MATCHES. Keyword Searches in a LiQL Query shows an example. I see that labels.text does support MATCHES when used as a constraint on messages collection queries. That might get you closer to what you need.

MattV's avatar
MattV
Khoros Staff

Using the IN keyword should get what you need.

So try:

SELECT * FROM messages WHERE labels.text IN ('Cats','Dogs','Birds')
Yulia-Anaplan's avatar
Yulia-Anaplan
Guide
4 years ago

Hi Matt,

Thank you for your response and help.
IN works as expected and does the job, yay.

I found a few different components with OR in our community and I am wondering if it always worked this way or something happened with OR and now it should be all changed using IN....