Is there any way of getting a list of workitem categories for a specific Project Area using BIRT?

Thank you Clement but those are not workItem-categories. Its not the same. I have defined 7 workitem-categories. I can't see those categories in the table you mention.

In order to see the workItem category you must follow these steps:

- Open Project Area ->Tab Project configuration -> Expand (+) Project configuration -> WorkItems -> Types and Attributes

Select a workItem type and you can see just in the right: Name, ID, Category, Icon...etc

I need to find that information in RTC DataWareHouse but I can't find it.

Best regards

Boris

Hello Clement

A workItem has two porperties:

WorkItemType and WorkItemCategory

This column WI_TYPE shows all workItemType, but doesn't show the workItemCategory

In the sreenshot, I can see com.ibm.team.apt.workItemType.story but I can't see com.ibm.team.workitem.workItemType.story

I fixed the issue using two filters. I used the filter "match"  to get by.

Thank you anyway.

I can't attach a image because I don't have more than 60 points, but I can explain it to you.

Lol. I did a fudge. I did it to get by. I'm sure this is not the better solutions but I don't have much time.
First I defined workitems that begin with the same string for the same workitem category. Then I made a match for that string.

<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OS" name="Orden de servicio"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSCV" name="Construcción VEGA"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSCB" name="Construcción HOST"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSCF" name="Construcción fatwire"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSCETL" name="Construcción ETL"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSCABAP" name="Construcción"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSDABAP" name="Diseño ABAP"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSMF" name="Modelo físico"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSCM" name="Construcción MIRA"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSRU" name="Revisión usabilidad "/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSPBI" name="Parametrización BI"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSPOMSAP" name="Parametrización"/>
<type category="com.ibm.san.vwp.OS" id="com.ibm.san.wi.OSDP" name="Diseño de procesos"/>

Then at the Birt Dataset I defined a filter in LIVE_WORITEM_CNT table to get all workItemsType for one Category

row["WI_TYPE"] match "com.ibm.san.wi.OS"