request for ZOQL to support joins for its queries

[Zuora-Community]

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.

[lukasz]

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]

Sorry disregard

[sidatsymantec]

disregard