Results Preview does not seem to work on ENUMERATIONS table
I'm using enumerations and cannot get a result preview back in the report designer in RTC 2.0 on the WORKITEM_SNAPSHOT.ENUMERATIONS table.
My question is what event triggers the population of the ENUMERATION table in the WORKITEM_SNAPSHOT? The following action did NOT update the ENUMERATION tables: - saving the Process Configuration template with the new enumerations - In RTC Web, on the Project's Report Menu, updating all the snapshot tables So when I create a data set and previewed the results of that data set (the data set is based on the WORKITEM_SNAPSHOT.ENUMERATION table) it does not return any results. I do not understand why I cannot get a results preview on the a simple data set of the ENUMERATION table? What event causes data to be put into the ENUMERATIONS table? However, following the steps from the video (http://jazz.net/library/video/288), I was able to get the custom enumeration values using the technique in the video. It is not at all intuitive though. |
One answer
The enumerations table is a live table. It does not get its data from the data warehouse. The table is also special in that it requires one project area to be passed as a data set parameter. In 2.0.0.1, you can set the PROJECT_AREA_ITEMID to '{Current Project Area}'.
In 2.0 you have to use the convoluted way of fetching the current project area and passing its item id as demonstarted in the video. |
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.