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

How to show customer attirbutes of work item in birt report?

I defined some customer attirbutes for work item
our client request show work item list with all atribute in a list report,and do some group account for some customer attirbutes.
The query result can show ,but client is not satisfied with it.
Then I try BIRT,
and can show the attributes which are defined by RTC which are store in RTC as a table column
but the customer attirbutes are not store in RTC as a table column,
I found they are stored by two column,one is string_key,the other is string_val,so a work item have serveral item in WORKITEMS_SNAPSHOT/LIVE_WORKITEM_CNT table.
Which means the customer attirbutes cannot be select and list.
I search related topics in jazz fortums,found that can define a WORKITEM QUERY REPORT,which use the data in WORKITEM_QUERY_RESULTS table.
I try ,but found the table is empty.
Is there anyone have the same problem?
can someone help to resolve it ?
thank you !!!

0 votes



One answer

Permanent link
Please refer to https://jazz.net/wiki/bin/view/Main/ReportsCentral
for reporting examples.

As long as BIRT can get the data, the form of the data really does not matter. BIRT has very powerful scripting features that will let you re-table the data.

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: Aug 11 '11, 2:55 a.m.

Question was seen: 4,496 times

Last updated: Aug 11 '11, 2:55 a.m.

Confirmation Cancel Confirm