How to trigger event on 'row' click in row generated by script_report?

koshish · July 14, 2016, 5:42am

how to trigger a event while clicking a row generated by script_report?

When I click a row of report I want to display(i.e msgprint) all the information of that row.

Please provide your suggestion.

nabinhait · July 14, 2016, 11:47am

May be formatter function in financial_statement.js will help.

frappe/erpnext/blob/develop/erpnext/public/js/financial_statements.js#L35


      
          		}
          
          
		return value;
          	},
          	"open_general_ledger": function(data) {
          		if (!data.account) return;
          		let project = $.grep(frappe.query_report.filters, function(e){ return e.df.fieldname == 'project'; });
          
          
		frappe.route_options = {
          			"account": data.account,
          			"company": frappe.query_report.get_filter_value('company'),
          			"from_date": data.from_date || data.year_start_date,
          			"to_date": data.to_date || data.year_end_date,
          			"project": (project && project.length > 0) ? project[0].$input.val() : ""
          		};
          
          
		let report = "General Ledger";
          
          
		if (["Payable", "Receivable"].includes(data.account_type)) {
          			report = data.account_type == "Payable" ? "Accounts Payable" : "Accounts Receivable";
          			frappe.route_options["party_account"] = data.account;

nabinhait · July 14, 2016, 2:28pm

You can also refer [Tutorial] Add Color to Cells in Query Report

koshish · July 17, 2016, 5:56am

Thank you for your suggestion

Mangesh_Bhuskute · August 24, 2018, 1:00pm

Will this solution work for ErpNext 5?