Help Filtering Child Items based on same child table field

vijaywm · May 22, 2021, 1:59am

Similar use case… Sales Invoice → items - filter UOM field based on Item selected in row.

frappe.ui.form.on("Sales Invoice", {
  setup: function (frm) {
    frm.set_query("uom", "items", function (doc, cdt, cdn) {
      let row = locals[cdt][cdn];
      return {
        query:
          "erpnext.accounts.doctype.pricing_rule.pricing_rule.get_item_uoms",
        filters: {
          value: row.item_code,
          apply_on: "Item Code",
        },
      };
    });
  },
});

related discussion:
https://discuss.frappe.io/t/filter-link-based-on-child-table-field-on-other-doctype/25898/5

In Erpnext:

github.com

frappe/erpnext/blob/94a52c0e1789a387c2f6777e58883543d004a3c9/erpnext/accounts/doctype/journal_entry/journal_entry.js#L228


      
          		}
          	}
          
          
	setup_queries() {
          		var me = this;
          
          
		me.frm.set_query("account", "accounts", function(doc, cdt, cdn) {
          			return erpnext.journal_entry.account_query(me.frm);
          		});
          
          
		me.frm.set_query("party_type", "accounts", function(doc, cdt, cdn) {
          			const row = locals[cdt][cdn];
          
          
			return {
          				query: "erpnext.setup.doctype.party_type.party_type.get_party_type",
          				filters: {
          					'account': row.account
          				}
          			}
          		});