current step report

Khang_Nguyen-Duy_(AVENTI04User3_(Delete)_2702352)

I am urgently looking for a report that shows me in which step each workflow is standing and maybe when this status has been changed for the last time.For example:workflow1 step 4 Last Change: 06/14/2002 workflow2 step 1 Last Change: 02/14/2002.....Thank you very much for your help.

Find more posts tagged with

Comments

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

Try this and let me know what you think:

select subwork_title "Workflow",
subworktask_title "Task",
subworktask_performerID_name "Assigned To",
max(workaudit_date) "Last Activity"
from todo, waudittrail
where todo.work_workid = waudittrail.workaudit_workid
and todo.subwork_subworkid = waudittrail.workaudit_subworkid
and todo.subworktask_taskid = waudittrail.workaudit_taskid
group by subwork_title, subworktask_title, subworktask_performerid_name
order by max(workaudit_date)

Regards,
Marie Lindsay

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, June 20, 2002 9:07 AM
To: eLink Recipient
Subject: current step report

current step report Posted by AVENTI04User3 (Nguyen-Duy, Khang) on 06/20/2002 10:04 AM

I am urgently looking for a report that shows me in which step each workflow is standing and maybe when this status has been changed for the last time.
For example:

workflow1 step 4 Last Change: 06/14/2002
workflow2 step 1 Last Change: 02/14/2002
.....

Thank you very much for your help.

Khang_Nguyen-Duy_(AVENTI04User3_(Delete)_2702352)

It works perfectly !!!Thank you very much, Marie.Regards,Khang