[Resolved] Export ZOQL: '>' and '<=' operators are not supported in Having clause for date type

[Yingying]

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 type

Workaround:

• Use >= instead of > to compare date type in the Having 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 the Having 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

[Yingying]

Status: Zuora engineering is working on the fix for the issue.

Reference Number: TOK-815

[Yong · Accepted solution]

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...