Happy Business Starts Here

request for ZOQL to support joins for its queries

request for ZOQL to support joins for its queries

Feature Request: Currently ZOQL queries do not support joins. This request is for ZOQL to support joins for its queries.

Reference Number: PMT-913

Business Need: 

The inability to join objects with queries results in our customers stepping through multiple objects to obtain data needed to execute key business use cases.

For example, to execute the Subscribe call, the ProductRatePlan.Id and ProductRatePlanCharge.Id are needed, and the customer must run at least 2 queries to obtain this data. I understand that caching is an option, but it does not always meet our customer's hosting conditions.

Another example is viewing Subscription Rate Plan details on a web site. Queries must be run on the RatePlanCharge, RatePlan, Subscription, and potentially Account objects to obtain this detail.

This is causing additional time & effort spent on building and maintain e-commerce use cases with Zuora.

5 Comments
Zuora-Community
Community Manager
Status changed to: New Idea
 
Zuora-Community
Community Manager
Status changed to: New Idea
 
lukasz
Zuora Product Team
Status changed to: Unlikely

Please take a look at our REST API's, which should be easier to work with. We're not planning to enhance the Transactional ZOQL to support joins.

sidatsymantec
New Student

 

Sorry disregard

sidatsymantec
New Student

disregard