Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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?

0 votes


Accepted answer

Permanent link
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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,495
× 481
× 360

Question asked: Nov 20 '18, 7:48 a.m.

Question was seen: 2,176 times

Last updated: Nov 26 '18, 11:59 a.m.

Confirmation Cancel Confirm