ZOQL IS NOT NULL

[kevburt]

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?

[Yong · Accepted solution]

How about something like this?

AmendmentType !=null

[mmayo]

Hello-

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.

[Yong]

I tested RatePlanCharge.EffectiveEndDate is null in UI Data Source export and I can get the expected result. Could you share the query you used?