Happy Business Starts Here

ZOQL IS NOT NULL

Highlighted
Tutor

ZOQL IS NOT NULL

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?

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Support SME

Re: ZOQL IS NOT NULL

How about something like this?

AmendmentType !=null

View solution in original post

3 REPLIES 3
Highlighted
Support SME

Re: ZOQL IS NOT NULL

How about something like this?

AmendmentType !=null

View solution in original post

Highlighted
Newly Enrolled

Re: ZOQL IS NOT NULL

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.

Highlighted
Support SME

Re: ZOQL IS NOT NULL

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? 

 

CleanShot 2020-04-16 at 17.51.03@2x.png