It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,790

question asked: Feb 07 '10, 11:36 a.m.
question was seen: 6,651 times
last updated: Feb 07 '10, 11:36 a.m.

Related questions

FAQ - How this Forum works

Custom Attributes in BIRT reports

0
Angelo Corna (261●4●83●81) | asked Feb 07 '10, 11:36 a.m.
Hi,

I've insert some custom attributes on my WorkItems.
How can I create a report with these attributes?
I've checked the LIVE_SNAPSHOT table but I can't find my attributes.
Is this the correct way in order to create BIRT reports with custom attributes?

Tanks in advance.

4 answers

Most liked answers ↓|Newest answers|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | answered Feb 09 '10, 3:53 p.m.
JAZZ DEVELOPER
Because you want to use the result of a work item query, you'll need to
join data from the workitem_query_results table with live_workitem_cnt
to retrieve the fields you want to report on.

james
RTC Reports Team Lead

On 2/9/2010 2:56 AM, ana.lopez wrote:
Hi,

Try with the WORKITEMS_SNAPSHOT as the data source

Using the LIVE_WORKITEM_CNT table you should be able to show the list of
work items.

If your custom attribute is of type string, use STRING_KEY as the id of
the attribute and STRING_VAL as the value.

I hope this helps,

Ana
On 2/8/2010 11:38 AM, angelo_corna wrote:
I've a workitem with a custom field.
I need a report with the result of a query that list all the workitems
created.
I've check the possibility to use the LIVE_SNAPSHOT table or the
WORKITEM_QUERY_RESULTS table but on both cases I cannot insert on the
report the custom field.
Is there a out of the box procedure for this issue?

Bye.
0
permanent link
Ana Lopez-Mancisidor (256●4●89●67) | answered Feb 09 '10, 3:08 a.m.
JAZZ DEVELOPER
Hi,

Try with the WORKITEMS_SNAPSHOT as the data source

Using the LIVE_WORKITEM_CNT table you should be able to show the list of
work items.

If your custom attribute is of type string, use STRING_KEY as the id of
the attribute and STRING_VAL as the value.

I hope this helps,

Ana
On 2/8/2010 11:38 AM, angelo_corna wrote:
I've a workitem with a custom field.
I need a report with the result of a query that list all the workitems
created.
I've check the possibility to use the LIVE_SNAPSHOT table or the
WORKITEM_QUERY_RESULTS table but on both cases I cannot insert on the
report the custom field.
Is there a out of the box procedure for this issue?

Bye.
0
permanent link
Angelo Corna (261●4●83●81) | answered Feb 08 '10, 5:24 a.m.
I've a workitem with a custom field.
I need a report with the result of a query that list all the workitems created.
I've check the possibility to use the LIVE_SNAPSHOT table or the WORKITEM_QUERY_RESULTS table but on both cases I cannot insert on the report the custom field.
Is there a out of the box procedure for this issue?

Bye.
0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Feb 07 '10, 4:27 p.m.
JAZZ DEVELOPER
Are you looking to report against live data or historical data from the data warehouse? A description of your report would also help.

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.