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

Birt report - How to fetch WI_ID in WS_STRING_EXT dataset?

From the dataset (pointing to WS_STRING_EXT) in BIRT designer, I couldn't find "WC_FACTID" and I was thinking it might be FACT_ID and tried to joint it with WORKITEM_CHNGS table FACT_ID and thus, have the WI_ID back but wasn't successful... Was I doing the right thing? Thanks.

0 votes



One answer

Permanent link
From the dataset (pointing to WS_STRING_EXT) in BIRT designer, I couldn't find "WC_FACTID" and I was thinking it might be FACT_ID and tried to joint it with WORKITEM_CHNGS table FACT_ID and thus, have the WI_ID back but wasn't successful... Was I doing the right thing? Thanks.


Clement,

I think this is the successful path:

From WS_STRING_EXT, select WS_FACTID. This is a fact id in the WORKITEM_STATES table. From WORKITEM_STATES, select the row with that FACT_ID, you will find a WI_ID (it automatically joins with the WORKITEM_CHNGS table so you don't need to do this yourself).

james

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: Oct 12 '10, 5:16 p.m.

Question was seen: 3,626 times

Last updated: Oct 12 '10, 5:16 p.m.

Confirmation Cancel Confirm