It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884

question asked: Jul 11 '11, 12:21 a.m.
question was seen: 4,842 times
last updated: Jul 11 '11, 12:21 a.m.

Related questions

workflow report - how to query Action and Resolution changes

0
Balasubramaniam Palani (26●1●2) | asked Jul 11 '11, 12:21 a.m.
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

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Jul 12 '11, 10:00 a.m.
JAZZ DEVELOPER
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.

Your answer

Register or 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.