Happy Business Starts Here

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

Zuora Documentation

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

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

 

 

Tags (2)
1 REPLY 1
Highlighted
Support SME

Re: [KNOWN ISSUE] Export ZOQL: '>' and '<=' operators are not supported in Having clause for