Step List Report

Bob_Weisman_(johcon05user3_-_(deleted))

I am trying to creating a report similar to the "Step List" report found in the Workflow Status area of an individual WF instance.I can retrieve ALMOST all the steps from the wsubworktask table.The only step that I can not seem to get data is the opening "Start Step".Does anyone know which table contains the data for the initial Start Step?

Bhupinder_Singh

Message from Bhupinder Singh via eLinkI ran some tests today and found that, in Livelink 9.2 SP1 at least, thedata for the initial start step is recorded in:Wmap.Map_PainterFor example, the Map_Painter value for a workflow I initiated contained:R<'TASKS'=V{<'PAINTER','TITLE','TYPE','SUBTYPE','TASKID'><{(30,50),'Thisis my start step name',A<1,?,'SetDueDate'=false,'Signature'=0>},'This ismy start stepname',1,100,0><{(134,133),?},'Alpha',1,104,1>},'LINKS'=V{<'FROMTASK','TOTASK','LINKTYPE'><1,2,0>}> Note that "This is my start step name" in the above assoc is the name Igave to the start step. I did not find this name present anywhere in theWSubWorkTask or the WMapTask tables. According to my limited testing, Icould only find it in the WMap table.Looking closer at the above assoc, we can see that it records thefollowing specific details:'PAINTER' --> {(30,50),'This is my start stepname',A<1,?,'SetDueDate'=false,'Signature'=0>},'TITLE' --> 'This is my start step name','TYPE' --> 1,'SUBTYPE'--> 100,'TASKID' --> 0Note: The start step always has a taskID of 0 (zero). The fact that wenever see a taskID of 0 (zero) in the WSubWorkTask.SubWorkTask_TaskIDcolumn demonstrates further that Livelink does not record the start stepdetails in the WSubWorkTask table.Hope that helps...- Bhupinder------------------------------------------------------ Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------ -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Thursday, February 03, 2005 10:58 AMTo: eLink RecipientSubject: Step List ReportStep List ReportPosted by Weisman, Bob on 02/03/2005 10:54 AMI am trying to creating a report similar to the "Step List" report foundin the Workflow Status area of an individual WF instance.I can retrieve ALMOST all the steps from the wsubworktask table.The only step that I can not seem to get data is the opening "StartStep".Does anyone know which table contains the data for the initial StartStep?[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