How do you make all your custom RTC attributes show up in Report Builder 6.0.3?

Jamie Berry (140●1●28●69) | asked May 03 '17, 1:51 p.m.

We have a project area where we have added several custom attributes to various work items in RTC 6.0.3. Some of these custom attributes are showing up as selectable attributes in Report Builder, but we have 2 attributes that are not. They are of type Deliverable and Iteration. Is there anything I can do to have these attributes show up for this project? Other standard fields of Deliverable and Iteration type are available.

Thanks,

Jamie.

Accepted answer

permanent link

Kenji Sarai (960●2●9) | answered May 03 '17, 9:00 p.m.
edited May 03 '17, 9:09 p.m.

Hi Jamie,

There is a similar question in the past.
https://jazz.net/forum/questions/232315/custom-attribute-of-type-deliverable-is-not-accessible-in-report-builder-jazz-reporting-service

https://jazz.net/forum/questions/216859/what-custom-rtc-fields-are-available-in-the-data-warehouse

I suppose all Deliverable type custom attributes are unavailable in JRS, but Iteration should be available in REQUEST_ITERATION_EXT. Does this custom attribute have a value in at least one workitem, and refresh the data source?

Jamie Berry selected this answer as the correct answer

Comments

Robert Huet commented Apr 04 '18, 11:24 a.m.

Yes, custom attributes of type "Iteration" are available in the Data Warehouse, but we can't get them to show up in Report Builder (v 6.0.4). The only way we can add them to our reports is using the Advanced SQL option. We have an open PMR on this.

It's all about the answers!

Related questions

How do you make all your custom RTC attributes show up in Report Builder 6.0.3?

Accepted answer

Your answer