Server script for getting child table values

1

Hi everyone,
Can somebody help me here , i need to get all child table row values using server script .

for mt in frappe.db.get_list(‘Doctype’,filters={‘field’:value}):
if mt:
for mtc in mt.get(“table_name”):
frappe.msgprint(mtc.field)

This is the code i have written , Getting an error saying object not iterable

1 Like
2

Try This Code


data = frappe.db.get_list(‘Doctype’,filters={‘field’:value})
if data:
	for mtc in data:
		doc = frappe.get_doc("Doctype",mtc['name'])
		for item in doc.get(“table_name”):
			frappe.msgprint(item.field)
3 Likes
3

@MiM Thank you very much , it is working.

4

hello,
by using this code I got this error -keyerror
can you please help me in this .