Post

2 followers Follow
0
Avatar

CZQL NOT LIKE

Hi,

Is there a way to do a NOT LIKE filter in CZQL query?

Example : WHERE Name NOT LIKE '$%'

Filter the entities having a name not starting with the $ char

Romain Cabannes Answered

Please sign in to leave a comment.

2 comments
Date Votes

1
Avatar

Hello Romain,

It's possible. The NOT keyword must be in the correct place. For example, the following query works: SELECT Name FROM User WHERE NOT Name LIKE '%test%'

I hope this helps.

Roland

Roland Pumputis 1 vote
Comment actions Permalink