Current workflow step

[cdfly]

Hello,
I'm developing a report that shows the workflow name and the current step it's on, does any one know how to determine what step a workflow is on in the database?

Thanks

 

[appnair]

Try to procure the schema of livelink.It is free after you sign an NDA.Alternativly this document from OT givs out a little bit of that information.
The canned livreports that come from OT also has a sample.Your clue is to look at the tabls that start with W
and if you run a simpl workflow observer step info it can be obtained.

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=13682418

Here's what I made personally for my reseearch and provided to a forum user

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=18041350&objAction=download&viewType=1

it has some info as well.Not sure if it has excatly what your req is

The schema is IP of OT so I generally do not put out queris here



Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[cdfly]

Thanks appnair, those are great instructions.
For our requirments we need to be able to show which task a running workflow is on, I'm not sure if grabbing the first subworktask_taskid where the date done is null will work or not, if the tasks always run sequentially maybe that would be the way to go

 

[appnair]

No if you procure the first link document,opentext explains how they figure out if a task is waiting or done and so on.How else would they be able to show "green".I would use those falgs to come up with a solution.



Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[cdfly]

Will do, thanks again for the help

 

[ehimel]

The example below is will give you the current task for all in process workflows based on workflow title.

select '!~<a href="/livelink/llisapi.dll?func=work.statusheader&workid=' || work_workid || '&subworkid=' || work_workid || '">' || subwork_title || '</a>' as "Workflow Overview", a.wf_valstr "CompanyCode", SUBWORK_TITLE as "Workflow", SUBWORKTASK_TITLE as "Current Step", SUBWORKTASK_DATEREADY as "Step Start Date", WORK_OWNERID_NAME, SUBWORKTASK_PERFORMERID_NAME as "Assigned To" from todo, wfattrdata a where subwork_title like '%%<workflow title>' and (a.wf_id =work_workid and a.wf_attrid = 6) order by a.wf_valstr ASC