It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Oct 12 '10, 5:16 p.m.
question was seen: 3,333 times
last updated: Oct 12 '10, 5:16 p.m.

Related questions

FAQ - How this Forum works

Birt report - How to fetch WI_ID in WS_STRING_EXT dataset?

0
Clement Liu (1.5k●5●42●49) | asked Oct 12 '10, 5:16 p.m.
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.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | answered Oct 13 '10, 10:14 a.m.
JAZZ DEVELOPER
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

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.