Birt report - How to fetch WI_ID in WS_STRING_EXT dataset?
One answer
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