ERPNext set default filter condition

mr_mithun · May 28, 2021, 6:12am

I have made a custom report in erpnext. In that, I can filter data by clicking add filter button. But I want to add that as a default filter. How can I fix it?

For more clarification here is the screenshot which I am expecting as default https://drive.google.com/file/d/1G8WGJiFKZMQfWR5Hqs8rwZxLrdGwwp6z/view?usp=sharing

Thanks in advance

kartik · January 19, 2019, 10:20am

If it’s a Script report, you can refer to the below code to add a default value to the filter.

github.com

frappe/erpnext/blob/develop/erpnext/accounts/report/accounts_payable/accounts_payable.js#L18


			"label": __("Company"),
			"fieldtype": "Link",
			"options": "Company",
			"default": frappe.defaults.get_user_default("Company")
		},
		{
			"fieldname":"ageing_based_on",
			"label": __("Ageing Based On"),
			"fieldtype": "Select",
			"options": 'Posting Date\nDue Date\nSupplier Invoice Date',
			"default": "Posting Date"
		},
		{
			"fieldname":"report_date",
			"label": __("As on Date"),
			"fieldtype": "Date",
			"default": frappe.datetime.get_today()
		},
		{
			"fieldname":"range1",
			"label": __("Ageing Range 1"),

bluesky · May 27, 2021, 11:21am

How can this be done in a query report?
(Script report are not available as I am hosting on Frappe Cloud.)

bluesky · June 3, 2021, 9:15am

Any suggestions for users who are not self-hosting? Ideally, this should be possible from the UI without the need to add a custom .js-script.
There is also an issue on this: https://github.com/frappe/erpnext/issues/25931