Happy Business Starts Here

Allow ZOQL to create complex queries

Allow ZOQL to create complex queries

 

Here are some examples of the ZOQL features I'd like to see added. These limitations are documented on Zuora's site here. https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/M_Zuora_Object_Query_Language

**Support parenthesis for order of operations

SELECT Id, Name FROM Account WHERE (CustomField1__c = true AND CustomField2__c = true) OR CustomField3__c = false

**Support "like" operator

SELECT Id, Name FROM Account WHERE Name like 'zendesk%'

**Support "in" operator

SELECT Id, Name FROM Account WHERE Id IN ('111111111', '22222222222', '33333333333', '4444444444')

**Support "order by"

SELECT Id, Name FROM Account ORDER BY CreatedDate DESC

Here are some examples of the ZOQL features I'd like to see added. These limitations are documented on Zuora's site here. https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/M_Zuora_Object_Query_Language

Support parenthesis for order of operations

SELECT Id, Name

FROM Account

WHERE (CustomField1__c = true AND CustomField2__c = true) OR CustomField3__c = false

Support "like" operator

SELECT Id, Name

FROM Account

WHERE Name like 'zendesk%'

Support "in" operator

SELECT Id, Name

FROM Account

WHERE Id IN ('111111111', '22222222222', '33333333333', '4444444444')

Support "order by"

SELECT Id, Name

FROM Account

ORDER BY CreatedDate DESC

2 Comments
Community Manager
Status changed to: More Feedback Needed
 
Community Manager
Status changed to: Under Consideration