Custom Attributes in BIRT reports

Are you looking to report against live data or historical data from the data warehouse? A description of your report would also help.

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.

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.

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.