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
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
    Posts: 1127
    Veteran Member
    2/8/2019 4:21 PM
      PfiWorkunit
      David Williams
      HDAustin13
      Advanced Member
      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
        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
          Posts: 31
          Advanced Member
          2/8/2019 8:13 PM
            Thank you for your helpful answer!
            FireGeek21
            Veteran Member
            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
              Posts: 31
              Advanced Member
              2/11/2019 12:07 PM
                Thank you FireGeek21!