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

Found In(release) of a workitem in Reports

Hi ,

How can I get hold of Found In(Release) of a workitem from the Workitem_Chngs table?

Thanks,
Bharath

0 votes



2 answers

Permanent link
On 12/8/2009 4:53 AM, littleheartb4u wrote:
Hi ,

How can I get hold of Found In(Release) of a workitem from the
Workitem_Chngs table?

Thanks,
Bharath


Hi Bharath,

This information isn't currently in the Workitem_Chngs table, but if you
have a Workitem_Chngs row, you can join with the LIVE_WORKITEM_CNT table
(by work item id) and select the FOUND_IN column to get the information
that you need.

james
RTC Reports Team Lead

0 votes


Permanent link
James, thanks for the reply.

--Bharath

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: Dec 08 '09, 4:46 a.m.

Question was seen: 5,048 times

Last updated: Dec 08 '09, 4:46 a.m.

Confirmation Cancel Confirm