Finding the RTC attribute 'Filed Against' History in Data Warehouse
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
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
Philippe Chevalier
JAZZ DEVELOPER Jan 17 '13, 8:53 a.m.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".
1 vote