How to create a BIRT report to display custom attributes.
I understand that LIVE tables in the Data Warehouse in 1.0.1 do not expose custom attributes.
I also understand that: 1) in 1.0.1 it is not recommended to create a report from a JDBC Data Source, 2) the JAZZ repository is not API, 3) that potentially changes would be required depending on DB vendor, etc. Anyhow, I need to figure out how to create a report that displays custom attributes of the type string. In my research I found several tables that store information on the custom attributes: WORK_ITEM_*_EXTENSIONS. Various of these tables have a column that actually stores the attributes (long, medium_string, string, timestamp, int attribute types). The WORK_ITEM_LARGE_STRING_EXTENSIONS however does not have the VALUE_COL column. Running the following query, I get a row for each of my custom attribute names, but not their values. select MODEL.WORK_ITEM.ID, MODEL.WORK_ITEM.SUMMARY, MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS.KEY_COL from MODEL.WORK_ITEM, PROCESS.PROJECT_AREA, MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS where MODEL.WORK_ITEM.WORK_ITEM_TYPE = '<my>' and MODEL.WORK_ITEM.PROJECT_AREA_ITEM_ID = PROCESS.PROJECT_AREA.ITEM_ID and PROCESS.PROJECT_AREA.NAME_COL = '<my>' and MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS.JZ_PARENT_ID = MODEL.WORK_ITEM.ITEM_ID Where are the values of custom attributes of the type string stored? Thanks in advance. Ana |
2 answers
I checked table by table in the JAZZ database for tables that have a column of the type CLOB, BLOB. I found a few, guessing that one of these tables store the actual value of a string type custom attribute.
The table name that I found more promissing was the REPOSITORY.CONTENT_STORAGE, however I tried to add this table to my previous SELECT SQL statement using all combinations of ID type columns in either MODEL.WORK_ITEM or MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS in my where clause but with no success. I then tried to add the REPOSITORY.ITEM_STATES to the SQL statement. It returns values, but I am not sure if they are right, neither know how to handle a BLOB/CLOB field value display in BIRT. So this is my latest select statement: select MODEL.WORK_ITEM.ID, MODEL.WORK_ITEM.SUMMARY, MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS.KEY_COL, REPOSITORY.ITEM_STATES.ITEM_VALUE, REPOSITORY.ITEM_STATES.ITEM_TYPE_DBID, REPOSITORY.ITEM_STATES.ITEM_UUID, MODEL.WORK_ITEM.ITEM_ID from MODEL.WORK_ITEM, PROCESS.PROJECT_AREA, MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS,REPOSITORY.ITEM_STATES where MODEL.WORK_ITEM.WORK_ITEM_TYPE = 'pir' and MODEL.WORK_ITEM.PROJECT_AREA_ITEM_ID = PROCESS.PROJECT_AREA.ITEM_ID and PROCESS.PROJECT_AREA.NAME_COL = 'EPMO - Prototype1' and MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS.JZ_PARENT_ID = MODEL.WORK_ITEM.ITEM_ID and MODEL.WORK_ITEM_LARGE_STRING_EXTENSIONS.KEY_COL = 'com.ibm.pmo.pir.attribute.executivesummary' and REPOSITORY.ITEM_STATES.ITEM_UUID = MODEL.WORK_ITEM.ITEM_ID Help! |
Perhaps someone on the work items team can comment.
james agiordano wrote: I checked table by table in the JAZZ database for tables that have a |
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.