Forum Discussion

isxtn's avatar
isxtn
Advisor
2 years ago

Can we constrain LiQL WHERE field != '' or empty or null or what have you?

I know that the constraints on LiQL queries are pretty limited but is there a way to search for something you wear that thing is not empty or "" or null or undefined?  For example: SELECT subject ...
  • VikasB's avatar
    2 years ago

    isxtn 
    No, this is not supported. It is a documentation bug. You may find a lot of ideas where people are looking for this to be implemented by Khoros but no luck yet. 

  • Akenefick's avatar
    2 years ago

    To expand on that a little, if you look at each constraint here messages (khoros.com) each one has a different list of supported operators. 

    So, for example author.id you can use !=

    But subject you can't