Add filters to custom query report

Frappe Framework Customization
,
2
  1. Create a file name with the report _name.js (e.g. sales_order_analytics.js)
  2. Add filter code as below in js file

frappe.query_reports[“Sales Order Analytics”] = {
“filters”: [

	{
		"fieldname":"from_date",
		"label": __("From Date"),
		"fieldtype": "Date",
		"width": "80",
		"default": frappe.datetime.month_start()
	},
	{
		"fieldname":"to_date",
		"label": __("To Date"),
		"fieldtype": "Date",
		"width": "80",
		"default": frappe.datetime.month_end()
	}
]

}

  1. Use in your query report
    select * from tabSales Order where date_time >= %(from_date)s and date_time <= %(to_date)s
2 Likes