How to fetch data from one child table to other child table of same doctype

Frappe Framework Custom Script
1

I have two child tables in same doc type. I want to fetch start date and end date from on child table to other. Is it possible? which script i can use?

2

You can view do by this script

frappe.ui.form.on("[CHILD_TABLE_TARGET_DOCTYPE]", {
	[CHILD_TABLE_LINK_FIELD]: function(frm, cdt, cdn) {
		var row = locals[cdt][cdn];
		if (row.[CHILD_TABLE_LINK_FIELD]) {
			frappe.model.with_doc("[SOURCE_DOCTYPE]", row.[CHILD_TABLE_LINK_FIELD], function() {
				var doc = frappe.model.get_doc("[SOURCE_DOCTYPE]", row.[CHILD_TABLE_LINK FIELD]);
				$.each(doc.[SOURCE_DOCTYPE_CHILD_TABLE] || [], function(i, r) {
					if(r.[SOURCE_CHILD_TABLE_FIELD] == frm.doc.[TARGET_PARENT_DOCTYPE_FIELD]) {
						var df = frappe.meta.get_docfield("CHILD_TABLE_TARGET_DOCTYPE","[TARGET_CHILD_TABLE_CUSTOM_FIELD]", frm.doc.name);
						df.options += ["\n" + r.[TARGET_CHILD_TABLE_CUSTOM_FIELD]];
					}
				})
			});
			frm.refresh_field("[TARGET_DOCTYPE_CHILD_TABLE]")
		}
	}
});

for more information visit Community Developed Custom Scripts · frappe/erpnext Wiki · GitHub

3

fetch%20data
fetch%20data1279×551 33.6 KB

I have to fetch this two fields to below table but there is no link except i get currently other fields fetched automatically when press generate schedule button. I tired code but i am getting error.