Script Report with filters that get data using SQL

[NCP]

Please check the reference:

How to apply filters for query report

Otherwise you can also use the server script from the UI side. [image] [image] Script: results = frappe.get_all('Task', fields=["name", "subject", "status"], filters=filters, order_by="name DESC" ) columns = [ {"fieldname": "name", "label": _("Job"), "fieldtype": "Link", "options": "Task", "width": 150}, {"fieldname": "subject", "label": _("Subject"), "fieldtype": "Data", "width": 150}, {"fieldname": "status", "label": _("Status"), "fieldtype": "Data", "width": 100…