Happy Business Starts Here

Need Rateplan name and id from a particular SKU?

Zuora Support

Need Rateplan name and id from a particular SKU?

Question:

Need Rateplan name and id from a particular SKU?

 

Solution:

The query contains two tables that are combined, rate plan name and ID comes under the "Rateplan" table and SKU comes under the "Product" table.

 

In ZOQL we cannot run the join query for both the tables as there is a limitation on the same instead, we can use DataQuery to fetch the data,

 

below is the Query for the same:

 

select rp.id,rp.name from rateplan rp join productrateplan prp on prp.id = rp.productrateplanid join product p on p.id = prp.productid where p.sku = 'SAL-00000027'

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √