It's all about the answers!

Ask a question

BIRT displaying workitem status

EclipseTalk . (32735960) | asked Jun 13 '12, 10:44 p.m.
edited Jun 13 '12, 10:45 p.m.
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

EclipseTalk . commented Jun 14 '12, 8:00 a.m. | edited Oct 10 '13, 4:57 a.m.

WORKITEM_STATES worked fine - Thanks for your help

One answer

permanent link
ankur sharma (66212228) | answered Jun 14 '12, 3:17 a.m.
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.

Your answer

Register or to post your answer.