Get Task List of Flow

Follow

Christian Del Angel

• May 31, 2021 21:35

Hello,

I request your support to get the list of tasks displayed in the Manage.

Checking the network tab in the browser I saw the following form

the purpose of this functionality is to show it in the eforms Report View.

Thanks for the support

Regards!

0

• 

  Patrick Franklin

  • June 07, 2021 17:06

  This can be accomplished by using a data grid control and populating it with data from the AgilePoint DB table - WF_MANUAL_WORKITEMS

  Here is the query we use:

  select NAME as [Task Name], ISNULL(FULL_NAME,WF_MANUAL_WORKITEMS.USER_ID) as [Assignee], CONVERT(VARCHAR(10),ASSIGNED_DATE,110) as [Assigned Date], CONVERT(VARCHAR(10),DUE_DATE,110) as [Due Date], CONVERT(VARCHAR(10),COMPLETED_DATE, 110) as [Completion Date], Status from WF_MANUAL_WORKITEMS left outer join WF_REG_USERS on WF_MANUAL_WORKITEMS.USER_ID = WF_REG_USERS.USER_NAME where PROC_INST_ID = '${ProcessID}' AND WF_MANUAL_WORKITEMS.STATUS <> 'Removed' order by Assigned_Date

  0

  Comment actions Permalink

Please sign in to leave a comment.