I was successful in using the following TYPE of Custom report, but today it is giving an error :
select * from `tabItem`
where name like %(name)s
Javascript:
frappe.query_reports['Test
Query Parameter'] = {
"filters": [
{
"fieldname":"name",
"label":__("Item
Name"),
"fieldtype": "Data",
}
]
}
Error :
Traceback (innermost last):
File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application
response = frappe.handler.handle()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call
return fn(*args, **newargs)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run
result = [list(t) for t in frappe.db.sql(report.query, filters)]
File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql
self._cursor.execute(query, values)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
for key, item in args.iteritems())
KeyError: 'name'
Any Idea?
regards
Akshay