- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-04-2019
12:34 AM
07-04-2019
12:34 AM
Update (March 12, 2020): This issue has been resolved in Zuora Billing Release 270.
Known Issue: In Export ZOQL,
>
and <=
operators are not supported in Having
clause for date typeWorkaround:
- Use
>=
instead of>
to compare date type in theHaving
clause in Export ZOQL.For example:Not supported
Workaround
select A.a, avg(A.b) from A
where B.name is null
group by A.a
having max(B.date)>'2019-05-01'select A.a, avg(A.b) from A where B.name is null group by A.a having max(B.date)>='2019-05-02'
- Use
<
instead of<=
to compare date type in theHaving
clause in Export ZOQL.For example:Not supported
Workaround
select A.a, avg(A.b) from A where B.name is null group by A.a having max(B.date)<='2019-05-01'
select A.a, avg(A.b) from A where B.name is null group by A.a having max(B.date)<'2019-05-02'
Status: Zuora engineering is working on the fix for the issue.
Reference Number: TOK-815
Solved! Go to Solution.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-12-2020
06:56 PM
03-12-2020
06:56 PM
The issue tracked in TOK-815 has been fixed in R270. Reference https://knowledgecenter.zuora.com/Zuora_Release_Notes/A_Zuora_Billing_Release_Notes/21_2020_New_Feat...
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-12-2020
06:56 PM
03-12-2020
06:56 PM
The issue tracked in TOK-815 has been fixed in R270. Reference https://knowledgecenter.zuora.com/Zuora_Release_Notes/A_Zuora_Billing_Release_Notes/21_2020_New_Feat...