Report Builder - ADV Query - retrieving system fields
![]()
CLM 605
No GCM
All,
I inherited an ADV SQL query from someone that retrieves all of the custom fields by work item type:
SELECT P.NAME As PROJECT, T.NAME AS WORKITEM_TYPE, D.NAME AS ATTR_NAME, D.LABEL AS ATTR_LABEL, D.DATATYPE AS ATTR_TYPE FROM RICALM.REQUEST_ATTRDEF D
JOIN RIODS.REQUEST_TYPE T ON T.REQUEST_TYPE_ID = D.REQUEST_TYPE_ID JOIN RIODS.PROJECT P ON P.PROJECT_ID = T.PROJECT_ID ORDER BY P.NAME, T.NAME, D.NAME, D.LABEL, D.DATATYPE ASC
However, it does not include the "OOTB" fields like Filed Against, Planned For etc...Any idea how to get that information as well?
|
Accepted answer
![]()
Hi,
Those fields are available in Advanced SQL as well. The easiest way for you to see how that works is to write a simple report in Report Builder that includes all of the fields you want and then look at the SQL generated for that report.
Amy
Mahari Hill selected this answer as the correct answer
|