[Vtigercrm-developers] vtws_query IS NULL operation

omri yona omri.yona at gmail.com
Mon Feb 22 12:14:09 GMT 2021

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:

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,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210222/09d89ed4/attachment.html>

More information about the vtigercrm-developers mailing list