Livereport on workflow steps assigned to the user

Olga_Bakushchyk_(offsup02admin_-_(deleted))

Hi,does anybody have a livereport he/she can share that excepts userid and returns all workflow steps that are assigned to that user and not completed and due dates are in the future?What are possible status code values?Any help appreciated. Olga.

Alex_Kowalenko_(x-eu0016039_-_(deleted))

Message from Alex Kowalenko via eLinkHi Olga,The following query should give you a starting point:select SubWork_Title "WF Title", SubWorkTask_Title "Task Title", SubWorkTask_Status "Status", SubWorkTask_DateDue_Min "Min Due", SubWorkTask_DateDue_Max "Max Due" from WSubWorkTask, WSubWork where SubWorkTask_SubWorkID = SubWork_SubWorkID and SubWorkTask_PerformerID = %1 and /* %1 is user type as User Input 1 */ ( SubWorkTask_DateDue_Min > getdate() or SubWorkTask_DateDue_Max > getdate() ) and /* due date in future (using SQL server function) */ SubWorkTask_Status > 0 and /* step not completed */ SubWork_Status > 0 /* subworkflow not done */Status code values:SubWorkTask_Status: -4 deleted, -3 finished, -2 killed, -1 done, 1 waiting,2 ready, 3 started, 4 suspended, 5 executing.SubWork_Status: -1 done, 1 executing.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Thursday, June 23, 2005 12:38 PMTo: eLink RecipientSubject: Livereport on workflow steps assigned to the userLivereport on workflow steps assigned to the userPosted by Bakushchyk, Olga on 06/23/2005 12:35 PMHi,does anybody have a livereport he/she can share that excepts userid andreturns all workflow steps that are assigned to that user and not completedand due dates are in the future?What are possible status code values?Any help appreciated. Olga.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe