Table (WSubWorkTask) > Column (SubWorkTask_Status) - What's the difference between 3 and 5?

The difference between 2 (ready) and 3 (started) are as follows: Is this correct?2 (ready): A task is in the assignee's assignments page.3 (strted): A task has been at least opened by a performer. What's the difference between 2 (ready) and 5 (executing)? Hiromi

Find more posts tagged with

Comments

Ryan_Long

The ready status indicates that the assignment is available to the user to perform. It is listed in their personal assignments but no work has yet begun.The executing status is for that brief time between when a user hits the send on button and when the task is actually completed.For a (very) brief description for the values and a list of some of the other available workflow status values, please see the attachment.-Ryan===Ryan LongSenior Product SpecialistOpen Text Customer Support===

Hiromi__Byrd_(tokeleuser4_-_(deleted))

Thank you for the attachment. I have a question about 5 (Executing). According to the desctiption of Executing, 5 should appear in the SUBWORKTASK_STATUS column for a very short time.However, the WSubWorkTask table in the attached Excel file, shows seven steps that have been Executing status for at least four days. According to the Workflow Status Value Description, thee should be either 2 or 3. This seems strange...Anyway,the LiveReport that I wrote is to show the current step for each Workflow instance, so I just used WSubWorkTask.SubWorkTask_Status in (2, 3, 5) and WWork.Work_Status not in (-2, -3). Because 5 stays so long, I have to include 5...

Tim_Hunter

based on the .xls you posted SUBWORKTASK_TASKID = 5 is only a short period of time. Judging by the output you are not showing the CURRENT step, but all steps, notice the SUBWORKTASK_DATEREADY and SUBWORKTASK_DATEDONE columns, if both are null it has not been to that step yet. Also notice you have TASKID 1-16 and TITLEs which should match the number of steps in your workflow.I think you are seeing what you are querying, but not what you are expecting.

Hiromi__Byrd_(tokeleuser4_-_(deleted))

Thank you.The excel file I posted is a LiveReport to show selected cloumns of WSubWorkTask for one MapObjectID. This LiveReprot is only for me to see what data is in WSubWorkTask table. Thus, this LiveReport shows all steps (-4 thru 5). The LiveReport shows several 5s since Monday. The steps that shows 5, according to the status description and the actual workflow status, should show either 2 or 3. For example, if you sort the excel file that I psoted by WorkID 7147102, UBWORKTASK_STATUS column doesn't show either 2 or 3 but -2, -1, 1, and 5 only for a long time.Select T.SUBWORKTASK_WORKID, T.SUBWORKTASK_SUBWORKID, T.SUBWORKTASK_TASKID, T.SUBWORKTASK_DATEREADY, T.SUBWORKTASK_DATEDONE, T. SUBWORKTASK_TITLE, T. SUBWORKTASK_STATUS, T.SUBWORKTASK_FLAGS from WSubWorkTask T, WWork W where W.Work_WorkID in (Select S.SubWork_WorkID from WSubWork S, WMap M where M.Map_MapObjID=7145216 and S.SubWork_MapID=M.Map_MapID) and T.SUBWORKTASK_WORKID=W.Work_WorkID ORDER BY T.SUBWORKTASK_WORKID**************************************************The LiveReport I needed to create is to see the current step of a Workflow (ObjectID=7145216). Select B.Work_WorkID, AA.WF_VALSTR "Project Name", AB.WF_VALSTR "Project Type", AC.WF_VALSTR "Doc/PO Number", TO_CHAR (AE.WF_VALDATE, 'YYYY/MM/DD') "Deadline", AF.WF_VALSTR "Priority", TO_CHAR (AG.WF_VALDATE, 'YYYY/MM/DD') "Release Date", T.SUBWORKTASK_TITLE "Next Step", W.SUBWORK_TITLE "Workflow Title" From WWork B, WFAttrData AA, WFAttrData AB, WFAttrData AC, WFAttrData AE, WFAttrData AF, WFAttrData AG, WSubWorkTask T, WSubWork W Where B.Work_WorkID in (Select S.SubWork_WorkID from WSubWork S, WMap M where M.Map_MapObjID=7145216 and S.SubWork_MapID=M.Map_MapID) and AA.WF_ID=B.Work_WorkID and AB.WF_ID=B.Work_WorkID and AC.WF_ID=B.Work_WorkID and AE.WF_ID=B.Work_WorkID and AF.WF_ID=B.Work_WorkID and AG.WF_ID=B.Work_WorkID and AA.WF_AttrID=2 and AB.WF_AttrID=3 and AC.WF_AttrID=15 and AE.WF_AttrID=4 and AF.WF_AttrID=6 and AG.WF_AttrID=5 and T.SUBWORKTASK_WORKID=B.Work_WorkID and T.SUBWORKTASK_STATUS in (2, 3, 5) and B.Work_Status not in (-2, -3) and B.Work_WorkID=W.SUBWORK_WORKID ORDER BY AE.WF_VALDATEThe LR result is as shown in the attachment. The column that says Next Step is actually the current step, which are the steps where SubWorkTask_Status are 2, 3, or 5. This query seems to be working, but I still don't understand why 5 stays in the SubWorkTask_Status for so many days...