Filter by Item Group

[Francisco_Buendia]

Hello,

At Doctype “Item” exist “Item Group” link field.

At “Quotation” I placed a “Select” custom field named “Item Group” including only a couple of item groups. What I want is that the user can only select items (obviously at items table) that belong to the item group selected.

I tried addapting codes like these:

Filtering Sales Order Item per company

Try this , frappe.ui.form.on("Sales Order", { item: function(frm) { frappe.call({ "method": "frappe.client.get_value", "args": { "doctype": "Item", "filters": {"company": cur_frm.doc.item}, "fieldname": ["company"] }, callback: function(r) { cur_frm.set_query("company", "items", function(doc, cdt, cdn){ return { "filters": { "frm.doc.company": ["=",r.message.company], } } }); } }); } });

Filter based on child table custom field

It works!!! Out of sheer frustration though I changed my setup so that I didn’t need to reference the child table for the filter, which made it easier for me to find a solution. I think I like that setup better, but I’ll use yours for another customization I have planned. Thank you! Here is the code I used to filter on a custom field not in a child table: cur_frm.fields_dict['multi_tc'].grid.get_field('mt_title').get_query = function(doc) { return { filters: [[ 'Terms…

But just can’t make it work.

Also… I found that it’s not possible to unset as “Reading Only” the field “item group” at “Quotation Item” doctype. (I’m using Frappe Cloud).

Any thought would be really helpful!