It's all about the answers!

Ask a question

Report Builder - ADV Query - retrieving system fields


Mahari Hill (486180198) | asked Nov 20 '18, 7:48 a.m.
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


permanent link
Amy Silberbauer (30657) | answered Nov 26 '18, 11:59 a.m.
JAZZ DEVELOPER
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

Your answer


Register or to post your answer.