[Ask] Get List from Doctype Childtable on Another Doctype Childtable

Frappe Framework Customization
1

Hi guys, have a great day and thank you for a great software.

I need help for some case.
I want to get a list from Doctype A childtable to be appear on Doctype B childtable as a selection
I’m a newbie in programing, and really appreciate for your help.
I attached the image below to make your understanding easier.

Once again, thank you.

image
image1841×865 98.7 KB

2

do you just want this as a select field or as a link? if just select field, you can write a python code/ javascript code to fetch that table as a list and then pass it as select field options using df property

options_list = [opt1, opt2, opt3, op4]

frm.set_df_property('field_name', 'options', options_list);
1 Like
3

Thanks for replying, and how exactly phython or javascript code looks like that i need to write?

4

there are tons of post in forum on how to get data from doctype and child tables and how to manipulate the said data to fit your needs,

5

Solved.

In Js

refresh: function(frm) {
 frm.set_query("triggerred_field_name", "childtable_name", function(frm, cdt, cdn) {
		var d = locals[cdt][cdn];
		return {
			query: 'apps.apps.doctype.doctype_name.doctype_name.query_name',
			filters: {
				dependant_field_name: d.dependant_field_name
			}
		}
	});
}

In Py

@frappe.whitelist()
def query_name(doctype, txt, searchfield, start, page_lan, filters):
dependant_field_name= filters.get('dependant_field_name')
result = frappe.db.sql("""
	SELECT distinct
		a.triggerred_field_name
	FROM
		`tabSource Doctype (childtable)` a
	WHERE
		a.parent = '{0}'
""".format(dependant_field_name))
return result

Thanks. Please close this thread.