BIRT Report to show list of WIs with value of custom enumera

On 2/3/2010 12:02 PM, ana.lopez wrote:

Hi,

I have created a new work item type from scratch and added a custom
enumeration attribute "Provider" with three values (ProviderA, ProviderB
and ProviderC).

I want a report BIRT to show the list of WIs (one column for the WI_ID,
other for WI_SUMMARY and other to show the value of the custom attribute).

Using the LIVE_WORKITEM_CNT table I am able to show the list of work
items but I am not able to find the column table that represents the
value of the custom "Provider" attribute.

Which is the data source (I am using WORKITEMS_SNAPSHOT) and dataset
tables I should access to get access to the custom enumeration type value?.

Thanks,

Ana

I'll assume your attribute is of type string. With LIVE_WORKITEM_CNT,
you pass as a data set parameter to STRING_KEY the id of the attribute,
and select STRING_VAL as a column. (Similarly INT_KEY/INT_VAL for
integer, etc.).

Hope this helps.

james
RTC Reports Team Lead

Hi James,

Many thanks. Using the STRING_KEY and selecting STRING_VAL of the table
I can access now to the enumeration and its values. Only problem is that
instead of returning the real string value (for example "ProviderA") the
query returns "Proveedor.literal.l1" for the first value,
"Proveedor.literal.l2" for the second value....

Do you know if relationship "Proveedor.literal.l1"<----> "Proveedor1" is
stored in any other table or is better just to include some javascript
in the report to do directly in BIRT the translation of values to show
to the user?

Many thanks,

Ana

On 2/3/2010 8:34 PM, James Moody wrote:

On 2/3/2010 12:02 PM, ana.lopez wrote:
Hi,

I have created a new work item type from scratch and added a custom
enumeration attribute "Provider" with three values (ProviderA, ProviderB
and ProviderC).

I want a report BIRT to show the list of WIs (one column for the WI_ID,
other for WI_SUMMARY and other to show the value of the custom
attribute).

Using the LIVE_WORKITEM_CNT table I am able to show the list of work
items but I am not able to find the column table that represents the
value of the custom "Provider" attribute.

Which is the data source (I am using WORKITEMS_SNAPSHOT) and dataset
tables I should access to get access to the custom enumeration type
value?.

Thanks,

Ana

I'll assume your attribute is of type string. With LIVE_WORKITEM_CNT,
you pass as a data set parameter to STRING_KEY the id of the attribute,
and select STRING_VAL as a column. (Similarly INT_KEY/INT_VAL for
integer, etc.).

Hope this helps.

james
RTC Reports Team Lead

Hi, anyone knows where the enumerations are stored in the RTC
datawarehouse to avoid writing this java scripting?

thanks,

Ana

On 2/3/2010 10:30 PM, ana.lopez wrote:

Hi James,

Many thanks. Using the STRING_KEY and selecting STRING_VAL of the table
I can access now to the enumeration and its values. Only problem is that
instead of returning the real string value (for example "ProviderA") the
query returns "Proveedor.literal.l1" for the first value,
"Proveedor.literal.l2" for the second value....

Do you know if relationship "Proveedor.literal.l1"<----> "Proveedor1" is
stored in any other table or is better just to include some javascript
in the report to do directly in BIRT the translation of values to show
to the user?

Many thanks,

Ana

On 2/3/2010 8:34 PM, James Moody wrote:
On 2/3/2010 12:02 PM, ana.lopez wrote:
Hi,

I have created a new work item type from scratch and added a custom
enumeration attribute "Provider" with three values (ProviderA, ProviderB
and ProviderC).

I want a report BIRT to show the list of WIs (one column for the WI_ID,
other for WI_SUMMARY and other to show the value of the custom
attribute).

Using the LIVE_WORKITEM_CNT table I am able to show the list of work
items but I am not able to find the column table that represents the
value of the custom "Provider" attribute.

Which is the data source (I am using WORKITEMS_SNAPSHOT) and dataset
tables I should access to get access to the custom enumeration type
value?.

Thanks,

Ana

I'll assume your attribute is of type string. With LIVE_WORKITEM_CNT,
you pass as a data set parameter to STRING_KEY the id of the attribute,
and select STRING_VAL as a column. (Similarly INT_KEY/INT_VAL for
integer, etc.).

Hope this helps.

james
RTC Reports Team Lead

If you are using a 2.0.0.1 RTC server or better, WORKITEMS_SNAPSHOT.ENUMERATIONS has the mapping.
You have to pass the project area item id or {Current Project Area} and the enumeration id as the BIRT Data Set Parameters.

Hi,

Thanks for your response but although I am using RTC 2.0.0.2 I am not
able to see any value in WORKITEMS_SNAPSHOT.ENUMERATIONS although I have
updated the Snapshot Data several times.

I have connected directly to the database tables and there is not any
table called ENUMERATIONS.

I have also listed the tables in the RTC web client (Reports Menu ->
Select WORITEMS_SNAPTHOST and click "List All TableS") and all tables
have a Table Logical Name and a Table Database Name (for example
WORKITEMS is related with WORKITEMS) but for the Table Logical Name
"ENUMERATIONS" the value for the Table Database Name is "undefined"

I don't know if this affects to what is shown in BIRT but I am afraid it
is related and probably this can be the problem. If the enumaration data
has not been loaded into the datawarehouse BIRT can not access to this data.

Have you experienced this problem before?

Thanks,

Ana


2/8/2010 6:08 PM, rjaouani wrote:

If you are using a 2.0.0.1 RTC server or better,
WORKITEMS_SNAPSHOT.ENUMERATIONS has the mapping.
You have to pass the project area item id or {Current Project Area}
and the enumeration id as the BIRT Data Set Parameters.

The enumerations aren't stored in the warehouse, sorry.

james
RTC Reports Team Lead

On 2/8/2010 11:45 AM, ana.lopez wrote:

Hi, anyone knows where the enumerations are stored in the RTC
datawarehouse to avoid writing this java scripting?

thanks,

Ana

On 2/3/2010 10:30 PM, ana.lopez wrote:
Hi James,

Many thanks. Using the STRING_KEY and selecting STRING_VAL of the table
I can access now to the enumeration and its values. Only problem is that
instead of returning the real string value (for example "ProviderA") the
query returns "Proveedor.literal.l1" for the first value,
"Proveedor.literal.l2" for the second value....

Do you know if relationship "Proveedor.literal.l1"<----> "Proveedor1" is
stored in any other table or is better just to include some javascript
in the report to do directly in BIRT the translation of values to show
to the user?

Many thanks,

Ana

On 2/3/2010 8:34 PM, James Moody wrote:
On 2/3/2010 12:02 PM, ana.lopez wrote:
Hi,

I have created a new work item type from scratch and added a custom
enumeration attribute "Provider" with three values (ProviderA,
ProviderB
and ProviderC).

I want a report BIRT to show the list of WIs (one column for the WI_ID,
other for WI_SUMMARY and other to show the value of the custom
attribute).

Using the LIVE_WORKITEM_CNT table I am able to show the list of work
items but I am not able to find the column table that represents the
value of the custom "Provider" attribute.

Which is the data source (I am using WORKITEMS_SNAPSHOT) and dataset
tables I should access to get access to the custom enumeration type
value?.

Thanks,

Ana

I'll assume your attribute is of type string. With LIVE_WORKITEM_CNT,
you pass as a data set parameter to STRING_KEY the id of the attribute,
and select STRING_VAL as a column. (Similarly INT_KEY/INT_VAL for
integer, etc.).

Hope this helps.

james
RTC Reports Team Lead

The ENUMERATIONS table is really just a view on live data from the
repository that we provide access to through the ODA layer. The data is
not stored in the data warehouse. But BIRT does have access to it,
through this ENUMERATIONS view.

james

On 2/9/2010 12:17 PM, ana.lopez wrote:

Hi,

Thanks for your response but although I am using RTC 2.0.0.2 I am not
able to see any value in WORKITEMS_SNAPSHOT.ENUMERATIONS although I have
updated the Snapshot Data several times.

I have connected directly to the database tables and there is not any
table called ENUMERATIONS.

I have also listed the tables in the RTC web client (Reports Menu -
Select WORITEMS_SNAPTHOST and click "List All TableS") and all tables
have a Table Logical Name and a Table Database Name (for example
WORKITEMS is related with WORKITEMS) but for the Table Logical Name
"ENUMERATIONS" the value for the Table Database Name is "undefined"

I don't know if this affects to what is shown in BIRT but I am afraid it
is related and probably this can be the problem. If the enumaration data
has not been loaded into the datawarehouse BIRT can not access to this
data.

Have you experienced this problem before?

Thanks,

Ana


2/8/2010 6:08 PM, rjaouani wrote:
If you are using a 2.0.0.1 RTC server or better,
WORKITEMS_SNAPSHOT.ENUMERATIONS has the mapping.
You have to pass the project area item id or {Current Project Area}
and the enumeration id as the BIRT Data Set Parameters.

HI,

i have fetched the values of required filed. It shown enumeration literal vales. How to i get related friendly names.

I am using RTC 3.0.1


Thanks in Advance,
Pugazh

Check the following WIKI for video tutorials. One of the tutorials details how to get the friendly names.

https://jazz.net/wiki/bin/view/Main/ReportsCentral
https://jazz.net/wiki/bin/view/Main/ReportsCentral#Plan_Items_by_Theme