All Active Tasks Report

Question

I am wanting a report which lists all active tasks. I note that there is a report called Advanced User Task Report where you need to select a user to see all their active tasks. Is there a report which lists all active tasks or is there a way to create one?

rickyc0004 · Accepted Answer

Hi Ireneb, 
 You can get a list of all tasks by creating a process report as below. 
 This will give you all the task and you can check a filter for "Active" status to get active tasks only.

gangadharr0001 · Answer

a!localVariables(
 local!taskStatuses: {
 "Assigned",
 "Accepted",
 "Completed",
 "Not Started",
 "Cancelled",
 "Paused",
 "Unattended",
 "Aborted",
 "Cancelled By Exception",
 "Submitted",
 "Running",
 "Error"
 },
 local!taskPriorities: {
 "Low","Normal","High"
 },
 a!gridField(
 label: "My Tasks",
 labelPosition: "ABOVE",
 instructions: "A list of all tasks for the current user",
 data: a!queryProcessAnalytics(
 report: cons!TAR_TASK_REPORT,
 query: a!query(
 pagingInfo: fv!pagingInfo
 )
 ),
 columns: {
 a!gridColumn(
 label: "Task ID",
 value: fv!identifier
 ),
 a!gridColumn(
 label: "Name",
 sortField: "c0",
 value: a!linkField(
 links: a!processTaskLink(
 label: fv!row.c0,
 task: fv!identifier
 )
 )
 ),
 a!gridColumn(
 label: "Priority",
 sortField: "c4",
 value: if(
 not(isnull(fv!row.c4)),
 index(
 local!taskPriorities,tointeger(fv!row.c4)+1,"Other"
 ),
 "Other"
 )
 ),
 a!gridColumn(
 label: "Status",
 sortField: "c5",
 value: 
 if(
 not(isnull(fv!row.c5)),
 index(
 local!taskStatuses,tointeger(fv!row.c5)+1,"Other"
 ),
 "Other"
 )
 ),
 a!gridColumn(
 label: "Assignee",
 sortField: "c1",
 value: concat(
 a!forEach(
 items: fv!row.c1,
 expression: if(
 runtimetypeof(fv!item) = 4,
 /*User is type 4; group is type 5*/
 user(fv!item, "firstName") & " " & user(fv!item, "lastName") & char(10),
 /*Adding char(10) adds line breaks to the list of names*/
 group(fv!item, "groupName")
 )
 )
 )
 )
 },
 rowHeader: 1
 )
)

Y 
 
 ireneb Please follow this code create one constant that pointing to all active task report you will get all active tasks report 
 
 Let me know any further help

All Active Tasks Report

Top Replies