It's all about the answers!

Ask a question

Finding the RTC attribute 'Filed Against' History in Data Warehouse


Anthony Omisade (1211) | asked Jan 17 '13, 5:57 a.m.
Good Morning,

I am trying to create a report that displays how long a particular work item was filed against a specific value.

Does anybody know where I can find the History of the Filed Against attribute of a work item in RTC in the Data Warehouse? I can't seem to locate anything relating to this in the Request History Table.

Thank you

Anthony

Comments
1
Philippe Chevalier commented Jan 17 '13, 8:53 a.m.
JAZZ DEVELOPER

Hello Anthony,  I am not a report writer Yet,  but looking around I found the following information.  Please review this document I think it may help you!

Using this link: https://jazz.net/wiki/pub/Main/ReportsDataDictionary/CALMReportingDataModel.xls

See row 148, 

REST API  Resource
workItem   

REST API Property      
category/qualifiedName

DB Table          
REQUEST_CATEGORY

DB Field   
NAME       

FM Model Table
Request       

FM Model Field   
Category Name

Description
The category to which the work item is assigned. In the UI, this is called "Filed Against".

Accepted answer


permanent link
Brian Fleming (1.6k11928) | answered Jan 17 '13, 8:49 a.m.
Did you check the REQUEST_HISTORY.REQUEST_CATEGORY_ID column?  The display name of the "Filed Against" attribute can be looked up from the REQUEST_CATEGORY table.
Anthony Omisade selected this answer as the correct answer

Comments
Anthony Omisade commented Jan 17 '13, 10:40 a.m.

Thanks Brian! This was spot on!

Best Regards

Your answer


Register or to post your answer.