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 Public Chat

Frappe Forum

How to apply filters for query report

ERPNext

NCP March 7, 2024, 5:42am 6

That for, you have to develop the server script report.

Thank You!