PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/11/2019 7:07 AM by  HDAustin13
SQL query to list all of work units in Rich Client
 6 Replies
Sort:
You are not authorized to post a reply.
Page 1 of 212 > >>
Author Messages
HDAustin13
IT programmer
Austin ISD
Basic Member
(42 points)
Basic Member
Posts:20


Send Message:

--
02/08/2019 11:13 AM
    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
    Private
    Private
    Veteran Member
    (3145 points)
    Veteran Member
    Posts:1059


    Send Message:

    --
    02/08/2019 11:21 AM
    PfiWorkunit
    David Williams
    HDAustin13
    IT programmer
    Austin ISD
    Basic Member
    (42 points)
    Basic Member
    Posts:20


    Send Message:

    --
    02/08/2019 2: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
    Private
    Private
    Veteran Member
    (3145 points)
    Veteran Member
    Posts:1059


    Send Message:

    --
    02/08/2019 2: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
    IT programmer
    Austin ISD
    Basic Member
    (42 points)
    Basic Member
    Posts:20


    Send Message:

    --
    02/08/2019 3:13 PM
    Thank you for your helpful answer!
    You are not authorized to post a reply.
    Page 1 of 212 > >>