Cutom script for the problem

ERPNext User Forum
1

I am new in ERPNext I want custom script for filter by item group.as I have uploaded a picture I want the all the item codes of item group of consumable by creating the new rows.please suggest script to solve this.

Screenshot%20(2)
Screenshot%20(2)1361×650 19.9 KB

2 
cur_frm.fields_dict['items'].grid.get_field('item_code').get_query = function(doc) {
    return {
        filters: [[
            'Item', 'item_group', '=', doc.item_group
        ]]
    }
};
3

not working.tried this before.I want the all item codes of item group consumable in separate row.

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

actually I think onchange event is required tofetch records