SELECT si.name AS ‘Job’, si.subject AS ‘Subject’, si.customer AS ‘Customer’, si.created_date AS ‘Description’, si.service_due AS ‘Service Due date’, si.status AS ‘Status’, si.employee_name AS ‘Assigned To’, si.due_date AS ‘Due Date’, si.employee_due_time AS ‘Employee Due Time (In Hours)’ F…

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", "opti…

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace Community Chat (new!)

Frappe Forum

How to apply filters for query report

ERPNext

NCP March 6, 2024, 9:55am 2

Hi @neha,

Please check the reference post: