Forum Discussion

Vanessa_Simao's avatar
Vanessa_Simao
Mentor
10 years ago

Lithium API V2 - Excluding information from query

Hello,

 

I'm new to the V2 API and I would like to know if anyone knows how can i do a query that excludes results that contain a certain text in the subject/body/etc

 

For example, something like this:

 

SELECT id, subject FROM messages WHERE subject NOT MATCHES "keyword"

 

Thanks in advance

    • Vanessa_Simao's avatar
      Vanessa_Simao
      Mentor
      10 years ago

      Yes I know the "NOT" operator is not supported (atleast I didn't find any reference on the documentation) but I was looking for an alternative to it.

       

      I know there is the "!=" but I would like a "doesn't contain" expression, something equivalent to MATCHES but for an exclusion.