I am trying an action query where the where clause is 'IS NOT NULL' but I get an error that this is a syntax error. What is the equivalent ZOQL?
Solved! Go to Solution.
Re: ZOQL IS NOT NULL
When I attempt to query for date fields that are null I get an error from the API. Use case:
I want to get all active and pending ratePlanCharges for a given ratePlan. Some are evergreen, and do not have an effectiveEndDate. If I use the clause: ```effectiveEndDate > today``` I only get non evergreen charges, if I try to add an `or effectiveEndDate is null` the API gives me an error saying null is an invalid value for the field.