Pulling child table in appraisal doctype

Frappe Framework Custom Script
1

i can pull/fetch one child table in appraisal but i can’t to pull two child table in one go.

i used be code :

@frappe.whitelist()
def fetch_appraisal_template(source_name, target_doc=None):
target_doc = get_mapped_doc(“Appraisal Template”, source_name, {
“Appraisal Template”: {
“doctype”: “Appraisal”,
},
“Appraisal Template Goal” “Appraisal Template Goals”: {
“doctype”: “Appraisal Goal”,
}
}, target_doc)

return target_doc

when i select appraisal Template, it display “Appraisal Template Goal”, but i want to display “Appraisal template Goals” child table also together with “Appraisal Template Goal”

appraisals
appraisals944×607 25.4 KB

This child table is “Appraisal Template Goal” and i have other Child table “Appraisal Template Goals” need to pull below but my above code is not working.

below is the two child table:

child
child969×831 38.3 KB

please help me

2

You can try to see if the below snippet helps

doclist = get_mapped_doc("Source Document", source_name,{
				"Source Document": {
					"doctype": "Target Document",
				},
				"Source Document Child 1": {
					"doctype": "Target Document Child 1"
				},
				"Source Document Child 2": {
					"doctype": "Target Document Child 2"
				}
		}, target_doc)

	return doclist
3

@Pawan, thanks for your help, but my problem not solved. Only coming fist one table.

Note: my “Target Document Child 1” and “Target Document Child 2” are using same child table that is (“Appraisal Goal”), not different.

@frappe.whitelist()
def fetch_appraisal_template(source_name, target_doc=None):
doclist = get_mapped_doc(“Appraisal Template”, source_name, {
“Appraisal Template”: {
“doctype”: “Appraisal”,

	},
	"Appraisal Template Goal":{
		"doctype": "Appraisal Goal" 
	},
	"Appraisal Template Goals":{
		"doctype": "Appraisal Goal"
	}
}, target_doc)
return doclist
4

problem solved by creating different child table