Forum Discussion

anmi's avatar
anmi
Adept
3 years ago

Select labels along with messages in one query

I query messages with  SELECT id, subject, search_snippet, body, cover_image.view_href, teaser, view_href, author, conversation.last_post_time, replies.count(*), metrics.views FROM messages W...
Community API
Rest API
  • Akenefick's avatar
    Akenefick
    3 years ago

    I found this:

    IN() Operator Syntax
    "fieldname": { "in": [ "value1", "value2", "value3" ] }

    Example:
    "board.id":{ "in":[ "stereos", "televisions" ] }

    So I think yours would look like this:

    "labels.text":{ "in":[ "Text1", "Text2" ] }
anmi's avatar
anmi
Adept

thanks, that worked. 

One more question (sorry to bother you further)

How would this LIQL constraint be in a JSON query

AND labels.text IN ('Text1','Text2')
Akenefick's avatar
Akenefick
Genius
3 years ago

I found this:

IN() Operator Syntax
"fieldname": { "in": [ "value1", "value2", "value3" ] }

Example:
"board.id":{ "in":[ "stereos", "televisions" ] }

So I think yours would look like this:

"labels.text":{ "in":[ "Text1", "Text2" ] }
  • anmi's avatar
    anmi
    Adept
    3 years ago

    Thank you very much for the quick response and help.