Set filter to link based on another field (In a child table)

Frappe Framework
1

When someone selects a “Marketplace”, the “Category” should filter for only the ones with this marketplace. Currently doing a client side script. Any better way to do this?

My child table:

image
image990×229 19.2 KB

The Category column is linked to this custom doctype:

image
image1020×211 15.6 KB

My current non-working script: (I have gone as far as getting an action happening when the “Marketplace” field is changed inside the child table. It does not set the filter to the “Category” column)
image

2

Hi @plague69,

As per your scenario,

Similarly, we prepared a few pieces of logic. please check the video.

Client Script:

frappe.ui.form.on("Test DocType", {
  onload: function (frm) {
    frm.set_query("item_code", "test_child", function (doc, cdt, cdn) {
      let row = locals[cdt][cdn];
      return {
        "filters": {
          "item_group": row.item_group
        },
      };
    });
  },
});

Output:

I hope this helps.

Thank You!

1 Like
3

@NCP absolute legend. Thank you. I was very stuck on how to get the row as well. This example explains many aspects!

4

How can we implement this onto a Dynamic Link. Looks like this does not work on Dynamic Link field-type.

5

Tested, it’s worked properly. please check it.

6

Well actually a Dynamic Link inside child table

Below is my script. I’m just trying to add a filter to the standard Payment Entry child table references

Screenshot from 2024-07-11 14-22-19
Screenshot from 2024-07-11 14-22-191077×459 24.2 KB

7

I have fixed the typo on *locals. Still not working

8

Paste the code, otherwise create a new thread for new issue, please!

9

Posting here itsel since I believe it falls under the same issue. But would create a new issue if required.

frappe.ui.form.on('Payment Entry', {
    onload: function (frm){
        frm.set_query("reference_name" ,"references", function (doc, cdt, cdn){
            let row = locals[cdt][cdn]
            return {
                filters: [
                    [row.reference_doctype, 'outstanding_amount', '>', 0]    
                ]
            };
        })
    }
})
10

will check

11

Hi @Nabyar,

It’s worked properly.

frappe.ui.form.on('Payment Entry', {
    refresh: function (frm){
        frm.set_query("reference_name" ,"references", function (doc, cdt, cdn){
            let row = locals[cdt][cdn];
            return {
                filters: [
                    [row.reference_doctype, 'docstatus', '=', 1],
                    [row.reference_doctype, 'company', '=', frm.doc.company],
                    [row.reference_doctype, 'customer', '=', frm.doc.party_name],
                    [row.reference_doctype, 'outstanding_amount', '>', 0]
                ]
            };
        });
    }
});

Output:

2 Likes