BIRT Report to show list of WIs with value of custom enumera
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 |
9 answers
On 2/3/2010 12:02 PM, ana.lopez wrote:
Hi, 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, 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, |
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, |
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 |
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, |
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 |
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.