I was fiddling with script report. But getting error. Please help me to find erro in following js and py files.
python:
def get_columns():
return [
"someField:Data:100",
"Type:Data:60"
]
def get_data(filters):
return [
['hello', 'world']
]
def execute(filters=None):
return get_columns(), get_data(filters)
js file
frappe.query_reports["Receivable List"] = {
"filters": [
{
fieldname: "someField",
label: "Some Field",
fieldtype: "Select",
options: "30\n45\n60",
default: 30
},
]
};
But i am getting following server error log in python script
[ERROR] 2021-07-14 20:17:34,886 | /home/frappe/frappe-bench/apps/frappe/frappe/app.py:
Site: erpnext.localhost
Form Dict: {
“cmd”: “frappe.desk.query_report.run”,
“filters”: “{"someField":"30"}”,
“report_name”: “Receivable List”
}
Request Error
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 67, in application
response = frappe.api.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/api.py”, line 59, in handle
return frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 24, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 64, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1075, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 539, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 205, in run
result = generate_report_result(report, filters, user, custom_columns)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 68, in generate_report_result
columns = [get_column_as_dict(col) for col in columns]
TypeError: ‘NoneType’ object is not iterable
[ERROR] 2021-07-14 20:17:34,892 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py:
New Exception collected with id: 2021-07-14 20:17:34.887294-172.19.0.1-fa5