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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.