How to filter data in link field on script report filter field?

ERPNext Reports
1

How to filter data in link field on script report filter field ?

2

https://frappe.io/docs/user/en/guides/app-development/overriding-link-query-by-custom-script

1 Like
3

is it possible to do the same thing in script report

4

did you find any solution?

5

Create your filters in the client code, not in the filter table.
Add the script below:

frappe.query_reports['report_name_here'] = {
    "filters": [
        {
            fieldname: "fieldname_here",
            label: "label_here",
            fieldtype: "Link",
            options: "doctype_of_link_here",
            filters: {
                "fieldname_in_link_doctype_here": ["operator_here", "valuefield_here"]
            },
        },
    ]
}

Make sure your reload page report before review

1 Like