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
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?