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

BIRT displaying workitem status

Hello,
How can i display in a BIRT report the workitems' status. I'm using a data set from LIVE_WORKITEM_CNT  there is a column STATE_NAME but it's not the status. I've created another data set from the table STATE and the column STATE_NAME but the STATE column is an ID + workflow state.
DO I need to create a sub query or a data set joint?  Is there a sample somewhere?
Thanks for your help

0 votes

Comments

WORKITEM_STATES worked fine - Thanks for your help



One answer

Permanent link
I would create a Joint Data Set joining LIVE_WORKITEM_CNT with STATE. Also have a look at WORKITEM_STATES. It might already have what you need.

2 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
× 324
× 230

Question asked: Jun 13 '12, 10:44 p.m.

Question was seen: 5,234 times

Last updated: Oct 10 '13, 4:57 a.m.

Confirmation Cancel Confirm