• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

SQL query to list all of work units in Rich Client

 6 Replies
 2 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
HDAustin13
Advanced Member Send Private Message
Posts: 31
Advanced Member
2/8/2019 4:13 PM
Hello All, I need to write a sql query to list of all work units that have been ran on the system (those that are shown in the Work Units, Rich Client tool) including all status of Completed, Failed, Cancelled, etc. Can any one please advise which database tables that I can use for this query? Thanks in advance. Han
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
2/8/2019 4:21 PM
PfiWorkunit
David Williams
HDAustin13
Advanced Member Send Private Message
Posts: 31
Advanced Member
2/8/2019 7:12 PM
Thanks David! The status in table PfiWorkunit table is numeric numbers. Do you have any idea what does 1,2,3, etc. mean? Han
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
2/8/2019 7:24 PM
0= Not Ready, 1=Ready, 2=Processing, 3=Failed, 4=Completed, etc. Check the WorkUnit form for the status descriptions and the order they show up is the same order of the numbers.
David Williams
HDAustin13
Advanced Member Send Private Message
Posts: 31
Advanced Member
2/8/2019 8:13 PM
Thank you for your helpful answer!
FireGeek21
Veteran Member Send Private Message
Posts: 84
Veteran Member
2/8/2019 9:51 PM

Here is a query along with the list of status codes:

select *

from [databaseName].PFIWORKUNIT W

where W.STATUS =

-- 1 => Ready

-- 2 => Processing

-- 3 => Failed

-- 4 => Completed

-- 5 => Cancel Requested

-- 6 => Cancelling

-- 7 => Cancel Failed

-- 8 => Cancelled

-- 9 => Not Ready

--10 => Waiting

HDAustin13
Advanced Member Send Private Message
Posts: 31
Advanced Member
2/11/2019 12:07 PM
Thank you FireGeek21!