How add filter in Report Builder

Mohammed_Redha · August 25, 2017, 2:28pm

Hi
I want to add filters: from date and to date where end date is current date
where I should write code and how?

nabinhait · August 25, 2017, 5:22pm

What kind of report are you making?

If it is a Query / Script report, you need to add a js file where you can specify filters.

frappe/erpnext/blob/master/erpnext/stock/report/stock_ledger/stock_ledger.js

// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// License: GNU General Public License v3. See license.txt

frappe.query_reports["Stock Ledger"] = {
	"filters": [
		{
			"fieldname":"company",
			"label": __("Company"),
			"fieldtype": "Link",
			"options": "Company",
			"default": frappe.defaults.get_user_default("Company"),
			"reqd": 1
		},
		{
			"fieldname":"from_date",
			"label": __("From Date"),
			"fieldtype": "Date",
			"default": frappe.datetime.add_months(frappe.datetime.get_today(), -1),
			"reqd": 1
		},

This file has been truncated. show original

Mohammed_Redha · August 25, 2017, 8:40pm

@nabinhait As I said it is Report Builder, I already tried the code above but it is not working.
Selection_002

nabinhait · August 26, 2017, 6:59am

If it is Report Builder, then you just need to apply filters once in the report and then from Menu save the report. It will save the applied filters as well.

Mohammed_Redha · August 26, 2017, 10:18am

@nabinhait How About save report filter for current date?
I am not able to save filter as function to get current date for filter.

nabinhait · August 26, 2017, 3:59pm

Currently, you cannot configure filter for current date in Report Builder. If you want that you need to create a Query / Script Date.

Mohammed_Redha · August 26, 2017, 4:12pm

@nabinhait Could you tell me How I can Add this feature to frappe?

nabinhait · August 26, 2017, 4:16pm

Sorry, I don’t have that much idea. You have dig into the code yourself.