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

Report having all the fields from two different type of work items using BIRT ?

Questions
Tags
Users
Badges
Abhinav Mishra
(144●31●39) edited
Sep 10 '14, 5:05 a.m.
How to generate a report having all the  fields from two different type of work items  using BIRT ?

If it's possible with RTC queries ??

0 votes

Comments
Donald Nong
Sep 08 '14, 8:02 p.m.
Your question is not so clear. Of course you can have all the fields from a work item type, but why two different types? Do the two types happen to have the same fields and you want to "merge" them together in the report? It will help if you can clarify your use case.

Abhinav Mishra
Sep 09 '14, 9:45 a.m.
 Hi Donald, Thanks for your response. I have two workitems let say "A" & "B". Both work items have different custom attribites I want to generate a report consist of attributes from both work items on basis of common attribute.

1 answer
5,962 views
0 votes

Accepted answer

Permanent link
Donald Nong
(14.5k●6●14) Sep 10 '14, 12:20 a.m.
Depending on what you are reporting and which table you choose, you may need to separate the intended work items from others rather than "combine" them. For example, if you choose the table WORKITEMS from the LIVE_SNAPSHOT, you already have the common attributes of _all_ the work items. In this case, you actually need to use the column WI_TYPE to filter the work items of the types you want.
Abhinav Mishra selected this answer as the correct answer

2 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.

Ask a question
Guidelines
FAQ
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
× 12,144
× 485
× 324

Question asked: Sep 08 '14, 3:16 a.m.

Question was seen: 5,962 times

Last updated: Sep 10 '14, 5:05 a.m.

Confirmation Cancel Confirm