Happy Business Starts Here

ZOQL: Support Parenthesis

ZOQL: Support Parenthesis

Support parenthesis like every other query language that has ever existed.

For fun google "query language that does not support parenthesis".

4 Comments
Community Manager
Status changed to: New Idea
 
Scholar
I've been asking for this from Zuora for years to no avail.
Zuora Product Team
Status changed to: Under Consideration

The SOAP ZOQL doesn't support parentheses today, but the Data Source ZOQL does. Would love to hear use cases where parentheses in the SOAP ZOQL would help. This may influence how we look at implementing queries in REST.

Valued Scholar

As others have requested, please add support for ().  We wanted/tried it with the AQuA APIs and it did not even return an error, but rather returned an incorrect result set likely because it just ignored the parens or the entire where clause.

 

We wanted to and tried:

 

"name": "Account",

"query": "select DefaultPaymentMethod.Id as DefaultPaymentMethodId, BillToContact.Id as BillToId, SoldToContact.Id as SoldToId, * from  Account where (updatedDate >= '2020-07-15T12:22:40-00:00' and updatedDate <= '2020-07-15T12:23:00-00:00')

OR

(updatedDate >= '2020-07-15T10:22:40-00:00' and updatedDate <= '2020-07-15T10:23:00-00:00')",

 

The result set above appears to return entire result set. I am not sure why, but extremely misleading.

 

We end up doing this, 83 times for each cache for 30 different caches (annoying)

 

"name": "Account-01",

"query": "select DefaultPaymentMethod.Id as DefaultPaymentMethodId, BillToContact.Id as BillToId, SoldToContact.Id as SoldToId, * from  Account where updatedDate >= '2020-07-15T12:22:40-00:00' and updatedDate <= '2020-07-15T12:23:00-00:00'",

 

"name": "Account-02",

"query": "select DefaultPaymentMethod.Id as DefaultPaymentMethodId, BillToContact.Id as BillToId, SoldToContact.Id as SoldToId, * from  Account where updatedDate >= '2020-07-15T10:22:40-00:00' and updatedDate <= '2020-07-15T10:23:00-00:00'",

 

etc...