Filter by "item_group" in child table "item" in quotation

Frappe Framework Custom Script
22

Hi,

Try below code,

frappe.ui.form.on("Quotation", "item_group", function (frm, cdt, cdn) {
    if(frm.doc.__islocal) {
        frappe.call({
            method: "frappe.client.get_list",
            args: {
                doctype: "Item",
                filters: {
                    "item_group": frm.doc.item_group,
                    "is_sales_item": 1
                },
                fields:["item_code", "item_name", "description", "stock_uom"]
            },
            callback: function(r) {
                    var items = [];
                    frm.clear_table("items");
                    for(var i=0; i< r.message.length; i++) {
                        var d = frm.add_child("items");
                        $.extend(d, r.message[i]);
                        if(!d.qty) d.qty = 1;
                        if(!d.uom) d.uom = d.stock_uom;
                    }
                    frm.refresh_field("items");
                }
        })
    }
});
23

Try with something like…

frappe.ui.form.on("Quotation", "item_group", function(frm) {cur_frm.fields_dict['items'].grid.get_field('item_code').get_query = function(doc) {
		return {
	        	filters: [
			['Item', 'item_group', 'in', doc.item_group]
			]
			}
      };
});
24

@Francisco_Buendia
not working

25

@schilgod it is printing all the items without selecting any item_group and customer.
filtering isn’t working, all the item is printed as bellow

Screenshot%20(8)
Screenshot%20(8)1347×649 24.7 KB

26

updated to “item_group” instead of “onload”, try again please

27

@schilgod

thanks a ton :blush:

here is final working script

frappe.ui.form.on("Quotation", "item_group", function (frm, cdt, cdn) {
    if(frm.doc.__islocal) {
        frappe.call({
            method: "frappe.client.get_list",
            args: {
                doctype: "Item",
                filters: {
                    "item_group": frm.doc.item_group,
                    "is_sales_item": 1
                },
                fields:["item_code", "item_name", "description", "stock_uom"]
            },
            callback: function(r) {
                    var items = [];
                    frm.clear_table("items");
                    for(var i=0; i< r.message.length; i++) {
                        var d = frm.add_child("items");
                        $.extend(d, r.message[i]);
                        if(!d.qty) d.qty = 1;
                        if(!d.uom) d.uom = d.stock_uom;
                    }
                    frm.refresh_field("items");
                }
        })
    }
});;
4 Likes