Happy Business Starts Here

Valued Scholar

Order Number Reference for Subscription using Data sources

Hi,

 

I am looking for an option to link Order# when Data Source is Subscription ,  When Order Item is selected as data source, I can map to Subscription, but when i select Subscription as Datasource I don't see Order or Order Item to select. 

 

I want a simple report to show which subscription belogs to which order.  Subscription "Version" field is no help , as on UI it referes to order number but in database it sotres only version number.

 

Thanx,

Chirag

3 REPLIES 3
Support SME

Re: Order Number Reference for Subscription using Data sources

Hi @chiragjha Object Order Item might help probably. Then you can get the Order and Subscription relationship. 

Reporting.png

Highlighted
Valued Scholar

Re: Order Number Reference for Subscription using Data sources

Hi Yong,

 

Thank you for the rpely. And yes that is what I try to resolve - why only certain type of data source support Subscripton to Order relation? Why i don't see Order object when i select Subscription?

 

Regards,

Chirag

Support SME

Re: Order Number Reference for Subscription using Data sources

The objects relationship is defined here https://knowledgecenter.zuora.com/CD_Reporting_And_Analytics/D_Data_Sources_and_Exports/AA_Introduct...

Order and Subscription do not have a direct relationship. 

Reference https://knowledgecenter.zuora.com/CD_Reporting_And_Analytics/D_Data_Sources_and_Exports/C_Data_Sourc...

 

If you are familiar with sql, you can try using Data Query to get the requested info too. https://knowledgecenter.zuora.com/DC_Developers/BA_Data_Query

Hope that clarifies your concern.