nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to report on Sub workflows?

DeloitteAdmin_(Delete)_2707331

Hello,I have a workflow which has a subworkflow within itI have created a report which lists the workflow.I would like to link from this report to a report which lists the details of the subworkflow..Where is subworkflow information stored? How is this data connected to the main workflow..Thanks,Asha

Find more posts tagged with

Comments

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

Message from Olson, Leonard <<A HREF="mailto:len.olson@rgsinc.com">len.olson@rgsinc.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

There are a set of LiveReports posted in this discussion that do exactly what you are asking for.

https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3216053&objAction=view&show=0

The first report produces a list of active workflows, with a details link that activates the second report. The second report lists all the sub-flows and individual steps contained in the main workflow.

As to your question about where the data is stored, you should order the schema document from OT, but in a quick and dirty overview; the main workflow is contained in a table called WWork. It has very basic data about the report, such as date initiated, who initiated it, and what the overall due date is --but it does not contain the title. The next table is WSubWork, which further describes the workflow, and all subflows. This is where you will find the title of the workflow, along with due dates and other information. The individual steps are contained in a table called WSubWorkTask, which tells you the task name, who has the task, when they got it and when it is due. These three tables can give you most of the status data you might need for tracking active workflows. In addition, attribute data is contained in WFAttrdata and comments are in WFComments.

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, December 15, 2003 10:56
To: eLink Recipient
Subject: How to report on Sub workflows?

How to report on Sub workflows?

Posted by DeloitteAdmin on 12/15/2003 10:55 PM

Hello,

I have a workflow which has a subworkflow within it

I have created a report which lists the workflow.

I would like to link from this report to a report which lists the details of the subworkflow..

Where is subworkflow information stored?

How is this data connected to the main workflow..

Thanks,
Asha

DeloitteAdmin_(Delete)_2707331

Howdy,I have used the reports you pointed me to and I also have the schema document..My forms are storing data in an SQL table, when I initiate my main workflow it kicks of a subworkflow and the data store in the SQL table is for the subworkflow...what I am trying to find is where is the SUBWORKFLOW id stored within Livelink schema, so that I can compare that to the subworkflow id in the SQL table and create a Livelink report..I've founf that the work_workid in the WWORK table is the id for the main workflow but i can not find where the subworkflow Id is stored..hope that makes more sense?Thanks,ASha

eLink User

Message from Eric Saavedra <<A HREF="mailto:esaavedr@opentext.com">esaavedr@opentext.com> via eLink

eLink

WSUBWORK table is the one you want toquery. This table has two columns: SubWork_WorkID and SubWork_SubWorkID. The SubWork_WorkIDwill always be the top-most parent workflow map of your workflow system. The SubWork_SubWorkIDwill be the specific workflow map you are looking for. If you have a row in thetable where SubWork_WorkID and SubWork_SubWorkID are the same, you know that rowrepresents the parent workflow.

When dealing with SQL tables of formsassociated with workflow maps, the VOLUMEID represents the SubWorkID.

Hope this helps.

Eric

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, December 16, 20033:35 PM
To: eLink Recipient
Subject: Thats not what I wasafter..

Thats not what I was after..		Posted by DeloitteAdmin on 12/16/2003 05:55 PM
In reply to: RE How to report on Sub workflows?		Posted by RGSINC01Admin (Olson, Len) on 12/16/2003 09:32 AM

Howdy,

I have used the reports you pointed me to and I also have the schema document..

My forms are storing data in an SQL table, when I initiate my main workflow it kicks of a subworkflow and the data store in the SQL table is for the subworkflow...

what I am trying to find is where is the SUBWORKFLOW id stored within Livelink schema, so that I can compare that to the subworkflow id in the SQL table and create a Livelink report..

I've founf that the work_workid in the WWORK table is the id for the main workflow but i can not find where the subworkflow Id is stored..

hope that makes more sense?

Thanks,
ASha