[Vtigercrm-developers] vtws_query IS NULL operation

[omri yona]

Hello all,

Try to run a simple query using vtws_query to get all record in my custom
module that field  firstnotetime IS NULL

the query:
SELECT * FROM <Custom module> WHERE  firstnotetime IS NULL

I get an error : token 'IS' Unexpected VALUE(IS), expected one of:
EQ,LT,GT,LTE,GTE,NE,IN,LIKE

This api does not support IS NULL? I think the api need to support that or
i am missing another way to ask this query?

Thank you for your help,
Omri
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210222/09d89ed4/attachment.html>