Link filtering according other field

[RustemHesenov]

Hello dear community,

I have problem with link field filtering.

I have 3 doc type.

Doctype 1: Brand names

Doctype 2: Model names

Doctype 3: Device

I want to filter “Model” field according selected brand on the upper field

I need your help!

[Yamen_Zakhour]

Set specific values in a field type Link

You can add a filter via Javascript: cur_frm.fields_dict.FIELD_NAME.get_query = function(doc,cdt,cdn) { return { filters:[ ['ASOCIATED_DATA_FIELD_NAME', '=', "VALUES"] ] } } You can replace the condition whit other that fit your case, for example “in” (in which case you should provide a list of values in “VALUES”), or “!=” or others.

If that didn’t help just search “Filter Link Fields”, you’ll get tons of results.

[NCP]

Hi @RustemHesenov,

Adding @Yamen_Zakhour answer,

You can also use standard link query by using set_query via the Client Script DocType from the desk.

So please check the documentation of the Overriding Link Query By Custom Script

Thank You!

[RustemHesenov]

Thank you @Yamen_Zakhour and @NCP!

frappe.ui.form.on("Devices", "onload", function(frm) {
    frm.set_query("device_model", function() {
        return {
            "filters": {
                "model_brand": frm.doc.devices_brand,
            }
        };
    });
});

With your contribution I implemented this code for filtering. Working correct!

Thank you for your support!