It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884
×1,230

question asked: Jan 17 '13, 5:57 a.m.
question was seen: 3,856 times
last updated: Jan 17 '13, 10:40 a.m.

Related questions

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

0
Anthony Omisade (12●1●1) | 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

1
permanent link
Brian Fleming (1.6k●1●19●28) | 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.


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.