It's all about the answers!

Ask a question

Custom Attributes in BIRT reports


Angelo Corna (26037865) | 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



permanent link
Rafik Jaouani (5.0k16) | 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.

permanent link
Angelo Corna (26037865) | 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.

permanent link
Ana Lopez-Mancisidor (24628666) | 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.

permanent link
James Moody (3.3k24) | 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.

Your answer


Register or to post your answer.