- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?