How to access fields of different doctypes which were submitted by the user in a report?

Saba_Fatima · November 1, 2022, 8:01am

I have created doctype A,B,C
I want to create a report so that i should be able to access all the entries of A,B,C which were submitted by the users.
Any Suggestions?

NCP · November 3, 2022, 6:44am

Hi @Saba_Fatima,

For the report, you can use a join query if doctype links with each other.

Base report Example:

github.com

frappe/erpnext/blob/develop/erpnext/crm/report/lead_details/lead_details.py#L93-L98


      
          		FROM
          			`tabLead` left join `tabDynamic Link` on (
          			`tabLead`.name = `tabDynamic Link`.link_name and
          			`tabDynamic Link`.parenttype = 'Address')
          			left join `tabAddress` on (
          			`tabAddress`.name=`tabDynamic Link`.parent)

Syntax:

Thank You!

Saba_Fatima · November 16, 2022, 4:28pm

Sorry for late reply,
Thank you for your help.