Question about LIVE_WORKITEM_CNT
Hi ,
I'm trying to extract CATEGORY_NAME from LIVE_WORKITEM_CNT table. From the documentation I understand that the subcategories are stored with a '/' separator. But when I display this column on report it shows just the lower level category.
For example, if a workitem is raised against ClearCase/UCM (UCM being the sub-category under ClearCase), when I display CATEGORY_NAME on the report it just gives UCM.
I see the same issue while using NEW_WI_COUNT.
Is this a bug, or is there a way to display subcategories along with the top level categories.
I'm using RTC 1.0.1.1
Thanks,
Bharath
I'm trying to extract CATEGORY_NAME from LIVE_WORKITEM_CNT table. From the documentation I understand that the subcategories are stored with a '/' separator. But when I display this column on report it shows just the lower level category.
For example, if a workitem is raised against ClearCase/UCM (UCM being the sub-category under ClearCase), when I display CATEGORY_NAME on the report it just gives UCM.
I see the same issue while using NEW_WI_COUNT.
Is this a bug, or is there a way to display subcategories along with the top level categories.
I'm using RTC 1.0.1.1
Thanks,
Bharath
One answer
LIVE_WORKITEM_CNT gets its data from the live repository and not from the data warehouse.
In 2.0 we have a more generic way of exposing the live data through the LIVE_SNAPSHOT schema. Using that, you will be able to get to the gategory item id and join it with the data warehouse CATEGORY table to get the fully qualified name of the category.
In 2.0 we have a more generic way of exposing the live data through the LIVE_SNAPSHOT schema. Using that, you will be able to get to the gategory item id and join it with the data warehouse CATEGORY table to get the fully qualified name of the category.