Tasks
Query to show tasks created per template along with status
Since Task template is not stored in Task details, we cannot show count based on task templates. However, we have tried to form a query with task subject considering that, when task templates are used, the subject are not altered. SELECT ...
Query to show status changes of a task
PGSQL & MSSQL: SELECT taskdet.taskid "Task ID", taskdet.TITLE "Task Title", std.STATUSNAME "Task Status", aau.first_name "Task Owner", aau1.first_name "Status changed by", LONGTODATE(tdh.operationtime) "Status changed in (Time)", std1.STATUSNAME ...
Task related reports
Sample Output and headers present in this report Goto reports -> New query report and executes the following SELECT taskdet.TASKID AS "Task ID", taskdet.MODULE AS "Module", taskprior.PRIORITYNAME AS "Priority", taskdesc.DESCRIPTION AS ...
Query to show request task details
PGSQL: SELECT wo.WORKORDERID AS "Request ID", tk.taskid "Task ID", tk.title "Task Title", tk.module "Task Module", sdu.firstname "Task Created By", LONGTODATE(tk.createddate) AS "Task Created Date", wo.TITLE AS "Subject", tk.isparent "Is Parent", ...
Query to show both task comments and worklog comments
MSSQL: SELECT "taskdet"."TASKID" AS "Task ID", "taskdet"."TASKID" AS "Task ID", "wotask"."WORKORDERID" AS "RequestID", cd.CATEGORYNAME AS "Request Category", "taskgroup"."QUEUENAME" AS "Group", "taskowner"."FIRST_NAME" AS "Owner", "taskdet"."TITLE" ...
Number of open and closed tasks per ticket
MSSQL: SELECT "wo"."WORKORDERID" AS "Request ID", "qd"."QUEUENAME" AS "Group", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS "Department", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", "icd"."NAME" AS "Item", "wo"."TITLE" ...