Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

workflow report - how to query Action and Resolution changes

Hi

I am trying to prepare a workflow report, showing Action, Resolution and State changes of a workitem by time. The report should show the flow of workitem through various Actions and Resolutions against timestamp.

Using BIRT I am not able to find where Action and Resolution changes are stored. I am able to get the values of all other custom attributes as well as state changes by time. But I am specifically interested in knowing the changes to Action and Resolution.

The other option is to extract the Workitem History from the database, but I am not able to find this anywhere in the tables.

Can anyone help me to locate the Action, Resolution and Work Item history in the tables, which can be queried through BIRT?

Thanks in advance.

Bala

0 votes



One answer

Permanent link
We currently do not store those in the 2.0 Data Mart. In the 3.0.1 Shared data warehouse we do store the resolution. But the field is only available to Cognos Reports using the RRDI Common Reporting framework.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 11 '11, 12:21 a.m.

Question was seen: 4,923 times

Last updated: Jul 11 '11, 12:21 a.m.

Confirmation Cancel Confirm