Is there any way to use workflow roles in a LiveReport?

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

We have workflows where the initiator assigns roles when the work is launched. We would like to be able to get our reports to show who was assigned to what role for active workflows. How would you do this?At a minimum we would need workflow title, date initiated, status (executing, suspended etc.) and role 1, role 2, role 3...

Find more posts tagged with

Comments

Srini_Venkataramani

I am faced with the same issue at present. I looked at the Schema and the Livreports book but could not locate where this information is stored. Any help is appreciated.Srini

Bhupinder_Singh

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

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

First, a general tip to finding information in the database when it comes to workflows:

1. Create a workflow and initiate it, but use unique words for the information you want to locate. For example, I created a workflow with three roles called RolePerson1, RolePerson2, RolePerson3.

2. For each of the main workflow tables (WMAP, WWORK, WMAPTASK, WSUBWORKTASK, etc), create LiveReports using the SQL:

select * from <table_name>

Format the reports to use the "AutoLiveReport" format, remove the "100" value in the record-limit field to get all records, or, modify the above SQL to be workflow instance specific in the event you have a very large number of records in a given table. A Livelink system report will reveal how many rows reside in each table.

3. Run the LiveReports and on the results page, use the browser's find-on-page function (CTRL+F in Internet Explorer) to search for the keywords used in step #1 above.

Using the above method, I was able to determine that role assignees are stored in the MAP_USERDATA column of the WMAP table. A sample entry in that column for a workflow I initiated shows:

A<1,?,'LL_Role'=A<1,?,'Data'=A<1,?,'PerformerInfo'={A<1,?>,A<1,?>,A<1,?>},'RoleNames'={'RolePerson1','RolePerson2','RolePerson3'},'RolePerformers'={35790,8300,24281}>,'SubType'=1,'Type'=1>>

Notice from the above that the roles:

RolePerson1

RolePerson2

RolePerson3

...are assigned to users having a KUAF.ID value of:

35790

8300

24281

...respectively. Issuing the query "select name, firstname, lastname from KUAF where ID in ( 35790, 8300, 24281)" confirms that those users are indeed the role-assignees.

Hope that helps...

- 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: Thursday, June 22, 2006 8:07 PM
To: eLink Recipient
Subject: RE Is there any way to use workflow roles in a LiveReport?

RE Is there any way to use workflow roles in a LiveReport?		Posted by amecas01user4 (Venkataramani, Srini) on 06/22/2006 08:03 PM
In reply to: Is there any way to use workflow roles in a LiveReport?		Posted by rgsinc01admin (Freihofer, Victoria) on 01/27/2003 04:47 PM

I am faced with the same issue at present. I looked at the Schema and the Livreports book but could not locate where this information is stored. Any help is appreciated.

Srini

Srini_Venkataramani

Message from Venkataramani, Srini via eLinkBhupinder - Thanks for the detailed info as Always - that is what I waslooking for!Srini-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Monday, June 26, 2006 6:55 AMTo: eLink RecipientSubject: RE RE Is there any way to use workflow roles in a LiveReport?