Newbie question - Livereport to query archived workflows

Hi,I have a workflow with a form that uses a SQL table for its submission mechanism. I am trying to write a Livereport against this table that will show me all archived workflows for this map only but am getting stuck at creating the joins between my custom table and the WSubWork table.Am I using the correct table to join to? Aruna

Find more posts tagged with

Comments

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

Message from Olson, Leonard <len.olson@rgsinc.com> via eLink

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

You might want to create a join with the WWork table as well --this table includes the top level information about a workflow. Here is the SQL for a LiveReport we use to show archived workflows, you may find some useful clues here:

SELECT SubWork_Title TITLE,
to_char (Work_DateInitiated,'MM/DD/YYYY') INITIATED,
to_char (Work_DateCompleted,'MM/DD/YYYY') COMPLETED,
(SELECT (to_char (WorkAudit_Date,'MM/DD/YYYY')) FROM WWorkAudit w1 WHERE WWorkAudit.WorkAudit_Status=6 AND w1.WorkAudit_WorkID=WWorkAudit.WorkAudit_WorkID) ARCHIVED,
(Work_DateCompleted-Work_DateInitiated+1) "#DAYS DURATION"
FROM WWork, WSubWork, DTree, WMap
WHERE dtree.dataid=wmap.map_mapobjid
AND WSubWork.SubWork_WorkID=WWork.Work_WorkID
AND subwork_mapid=map_mapid
AND dtree.dataid IN('977166', '977341', '1867754', '1255850', '1257044', '2585978')
AND work_dateinitiated >= %1
and work_dateinitiated <= %2
AND Work_Status= -1
ORDER BY Work_DateCompleted
Data ID #s are IDs of workflow templates, %1 and %2 are date inputs for the user

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, March 31, 2004 10:39 PM
To: eLink Recipient
Subject: Newbie question - Livereport to query archived workflows

Newbie question - Livereport to query archived workflows

Posted by ActelUser1 (Tata, Aruna) on 03/31/2004 10:36 PM

Hi,

I have a workflow with a form that uses a SQL table for its submission mechanism. I am trying to write a Livereport against this table that will show me all archived workflows for this map only but am getting stuck at creating the joins between my custom table and the WSubWork table.

Am I using the correct table to join to?

Aruna