The report filter didnt filter the get_query()

SinChan4896 · September 8, 2022, 9:55am

why the get_query() still output the is_active: No in the filter, do i missing something?

Solufy · September 8, 2022, 10:10am

Please check it reference.

frappe/erpnext/blob/develop/erpnext/selling/report/sales_order_analysis/sales_order_analysis.js#L32-L46


      
          		{
          			"fieldname": "sales_order",
          			"label": __("Sales Order"),
          			"fieldtype": "MultiSelectList",
          			"width": "80",
          			"options": "Sales Order",
          			"get_data": function(txt) {
          				return frappe.db.get_link_options("Sales Order", txt);
          			},
          			"get_query": () =>{
          				return {
          					filters: { "docstatus": 1 }
          				}
          			}
          		},

Hope you understand.

Thank You!

Nebiye_Lioul1 · June 2, 2024, 11:35pm

Reports like General Ledger have this implementation. checked in v13 and it works.

get_data: function(txt) {
     return frappe.db.get_link_options("Project", txt, {
           "is_active": "Yes"
     }
}