How to Create LiveReport for Existing Workflow

Hi, I am learning Live report and I don't know much about it. But I need to create report which will give me information With each workflow I need to seethe attributes such as description, status, assigned to, and created by.

Find more posts tagged with

Comments

eLink User

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

Try running a search in the LiveReport Discussion for the kind of report you want.

In the meantime try using this SQL for workflow status. We run this report and then copy and paste into Excel for sorting.

BE SURE TO REPLACE THE NODE IDs IN THIS SQL WITH YOUR OWN IDs FOR YOUR WORKFLOW TEMPLATE(S).

This is written for Oracle:

----------------------------------------------

SELECT
subwork_title "TITLE",
TO_CHAR(work_dateinitiated , 'MM/DD/YYYY') "INITIATED",
subworktask_title "TASK NAME", TO_CHAR(subworktask_dateready, 'MM/DD/YYYY') "DATE RECEIVED", TO_CHAR(work_DateDue_Max, 'MM/DD/YYYY') "DUE DATE",
DECODE ((SELECT '*' FROM WWork w1 WHERE WWork.Work_DateDue_Max < SYSDATE AND w1.Work_WorkID = WWork.Work_WorkID), '*', 'Overdue', NULL, ' ') AS "LATE",
DECODE(kuaf.type, 0, kuaf.lastname || ', ' || kuaf.firstname, 1, kuaf.name) "PERFORMER NAME", decode(work_status,2,'Executing',1,'Suspended',-2,'Stopped') "WORKFLOW STATUS", decode(subworktask_status,2,'Ready',3,'Started',4,'Suspended',5,'Executing') "TASK STATUS"
FROM
wwork, kuaf, wsubworktask, wworkaudit, wsubwork, dtree, wmap
WHERE
(dtree.dataid=wmap.map_mapobjid)
AND dataid IN('977166', '977341', '1867754', '1255850', '1257044')
AND subwork_mapid=map_mapid
AND kuaf.id=subworktask_performerid
AND subworktask_workid=work_workid
AND work_workid=workaudit_workid
AND work_workid=subwork_workid
AND (subworktask_status=2 or subworktask_status=3 or subworktask_status=4 or subworktask_status=5)
AND workaudit_status=1
AND NOT work_status<=-1
AND NOT subworktask_status<=1

----------------------------------------------

Good luck,

Len Olson

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, April 03, 2003 12:27
To: eLink Recipient
Subject: How to Create LiveReport for Existing Workflow

How to Create LiveReport for Existing Workflow Posted by elpasouser2 on 04/03/2003 12:20 PM

Hi,
I am learning Live report and I don't know much about it. But I need to create report which will give me information With each workflow I need to see
the attributes such as description, status, assigned to, and created by.

Livelink_Admins_Essential

Absolutely brilliant piece of coding, we run SQL, and obv, livereports doesn't understand the decode function. I am looking for a Live report to show what workflow is late and whose personal workspace it is in, and what action they need to take.I know someone has to have wrtten something like this, it seems like such a basic report.