Date Workflow last Initiated

Robert_Anderson_(robanderson_-_(deleted))

From what I'm seeing in the 9.7 schema, the workflow tables are a mess.Right now, I have a report that brings up all workflows and their last audit date. select d.*, (select max(auditdate) from dauditnew where dataid=d.dataid and auditstr = 'Fetch') maxdate from dtree d where d.ownerid != -14044287 and d.subtype=128 order by d.nameHowevern "Initiated" isn't an event. What tables do I query to figure out for a particular workflow object when the last time a workflow as initiated from it?

Find more posts tagged with

Comments

Appu_Nair

if auditing is turned on for every workflow that is initaiated form a map object you should see in the audit Version Opened 08/05/2008 12:14 PM Admin Version Opened 08/04/2008 01:37 PM Tom **** (tdick) Version Opened 08/04/2008 01:01 PM Jane Doe (ljerrols) Version Opened 08/04/2008 12:03 PM Admin Version Opened 08/04/2008 11:21 AM Admin Version Opened 08/04/2008 10:22 AM Jane Doe (ljerrols) Version Opened 08/01/2008 02:00 PM Ingrid Hulk (cmoffitt) Version Opened 08/01/2008 01:41 PM Admin This is initiate event for the workflow.So if you know the map objid one could write something likeSELECT * FROM livelink.lluser.DAuditNew WHERE AuditStr='Fetch' and dataid=

also experienced livelink workflow developers do create a master manager group for managing a particular map object.This is an efffective filter so that you can write queries easily

Appu_Nair

also wanted to say this there could be some false positives,like if I was a map designer then opening the map for painting also produces this event so one might look at the perfomer and eliminate the events if the user is a designer.Also you could just open up the workflow and sit there and that vent will also show up you don't need to initiate it

Robert_Anderson_(robanderson_-_(deleted))

Unfortunately the way we have things set up right now that's not possible.So, we need a better way to see when the workflow was last actually initiatet, not just opened or painted.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Try this:

Report Title:

Last Date Initiated - Active Workflows

SQL Query (Oracle specific -- not tested on SQL Server):

select max(WSubWork.SubWork_DateInitiated) LastInitiated, count(WSubWork.SubWork_DateInitiated) TimesInitiated, %1 from WSubWork, WMap, DTree where (DTree.SubType=128) and (WMap.Map_MapObjId = DTree.DataId) and (WMap.Map_MapId = WSubWork.SubWork_MapID) group by %1 order by TimesInitiated desc, LastInitiated desc

Param %1 = Report Fields

Report Format: LiveReport

Display Columns (Field -- Column Title):

LastInitiated -- Last Initiated On

TimesInitiated -- Number of Times Initiated

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 06, 2008 11:52 AM
To: eLink Recipient
Subject: Unfortunately the way we have things set up right now that's not possible.

Unfortunately the way we have things set up right now that's not possible.		Posted by robanderson (Anderson, Robert) on 08/06/2008 11:49 AM
In reply to: also wanted to say this there could be some false positives,like if I was a map...		Posted by anair@alitek.com (Nair, Appu) on 08/06/2008 11:35 AM

Unfortunately the way we have things set up right now that's not possible.

So, we need a better way to see when the workflow was last actually initiatet, not just opened or painted.

Robert_Anderson_(robanderson_-_(deleted))

You're amazing!Thanks so much, just what I need.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Thanks go to my colleague, Lori Himsl, who came up with the SQL. I just happened to remember seeing it once somewhere before :-)

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 06, 2008 1:34 PM
To: eLink Recipient
Subject: You're amazing!

You're amazing!		Posted by robanderson (Anderson, Robert) on 08/06/2008 01:32 PM
In reply to: RE Unfortunately the way we have things set up right now that's not possible.		Posted by bsingh (Singh, Bhupinder) on 08/06/2008 12:11 PM

You're amazing!

Thanks so much, just what I need.