LiveReport with link/details that will open a workflow

I would like to create a LiveReport that will have columns of data as well as a "Details" or link that you can click on that will open a workflow. When I say open workflow, I would like to open something like a Workflow Status. The problem with a Worflow Status is that you can't pass parms to it because I only want to open one given workflow by the ID being passed. Hopefully someone understands what I am looking for, if not, I will try to explain a little better. Thanks!

Find more posts tagged with

Comments

Bhupinder_Singh

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

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

Would the existing LiveReport that ships with the product, titled "Workflow Status By [ID]" , meet this requirement?

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, September 27, 2006 4:11 PM
To: eLink Recipient
Subject: LiveReport with link/details that will open a workflow

LiveReport with link/details that will open a workflow

Posted by todfunk (Funk, Tod) on 09/27/2006 04:08 PM

Tod_Funk

Well, that helps some. What the users would like is to be able to link directly to what a Workflow Status does. The Workflow Status will allow you to open up the workflow and see the attachments, map, steps, etc. That is what they would like to have. So, maybe a Livereport is no the best solution, but Workflow Status will not allow parameters to be passed in. So I was trying to figure out how to open something like a Workflow Status using a LiveReport that would allow me to pass in something like the workflow ID. Is there a Workflow Status that can be called?

Stefan_Becker_(stefanbecker_-_(deleted))

If you are searching for something like shown in this picture you can try to adopt the following mix of sql and html to your needs.regards Stefanselect '!~' || ' click here to manage this workflow (works only if you are manager of the workflow)

click here to manage this workflow (works only if you are manager of the workflow)

', '16submap.gif" alt="click here to manage this subworkflow (works only if you are manager of the subworkflow)">') || ' ' || wsw.subwork_title || '' "Workflowtitle", TO_CHAR(ww.work_dateinitiated , 'MM/DD/YYYY') "INITIATED", '!~' || decode(wswt.subworktask_performerid, NULL, ' ', ' ') || ' the steps inside this subworkflowstep are shown separate beneath

the steps inside this subworkflowstep are shown separate beneath

', 104, '16initiato.gif" alt="click here process this step (works only if you are performer of the step)">', '16user.gif" alt="click here process this step (works only if you are performer of the step)">') || ' ' || subworktask_title || '' "TASK NAME", TO_CHAR(wswt.subworktask_dateready, 'MM/DD/YYYY') "DATE RECEIVED", TO_CHAR(wswt.SubWorkTask_DateDue_Max, 'MM/DD/YYYY') "TASK DUE_DATE", '!~' || decode(wswt.subworktask_performerid, NULL, ' none' || decode(wswt.subworktask_performerid, NULL, '' "Performer" FROM wwork ww, kuaf k, wsubworktask wswt, wsubwork wsw, wmaptask wmt WHERE wmt.maptask_mapID = wsw.subwork_mapID and wmt.maptask_taskID = wswt.SubWorkTask_TaskID and k.id(+) = wswt.subworktask_performerid and wsw.subwork_subworkid = wswt.subworktask_subworkid AND (wswt.subworktask_status = 2 or wswt.subworktask_status = 3 or wswt.subworktask_status = 4 or wswt.subworktask_status = 5) AND NOT wswt.subworktask_status <= 1 AND wswt.subworktask_workid = ww.work_workid AND NOT ww.work_status <= -1 AND ww.work_workid = wsw.subwork_workid and wsw.subwork_workid in (select wsw2.subwork_workid from wsubwork wsw2, wmap wm where wsw2.subwork_mapid = wm.map_mapid and wm.map_mapobjid = %1) ORDER BY ww.work_dateinitiated, wsw.SubWork_ReturnSubWorkID, wmt.maptask_subtype

Toby_Bartlett_(hanafb04_-_(deleted))

Hi Stefan,how do you use this exactly?Can you put it into a Livereport??

Christine_Vital

I am looking for information on this as well. I looked at the suggested wf status by ID and it's not what I need. I want to be able to report on wf status and from that report drill into the specific workflows. So first report would give type of workflow (selectable), date range, and status. From that report I want to be able to click on the data reported and go directly to a workflow of interest.Is this possible?

Mary_Slane_Corona

I'm interested in this as well.Thank you.

Gunta_Luse

To get WF link working you need to return: Subtype, SubWorkID as DATAID, SubWork_Title as Name, SubWork_SubWorkID, Work_WorkID

Subtype for initiated WF instance is 189.

If you will include all these columns in the report and will choose "LiveReport" format, it will show workflow names as working links.

Gunta

NoorFatihah_Hassan

HI Gunte,

"To get WF link working you need to return: Subtype, SubWorkID as DATAID, SubWork_Title as Name, SubWork_SubWorkID, Work_WorkID"

I know subtype is from dtree, subwork_title and subwork_subworkid are from wsubwork, work_workid is from wwork.

Which table is SubWorkID coming from?

Thanks!