It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,854

question asked: Nov 10 '11, 3:51 p.m.
question was seen: 5,779 times
last updated: Jun 18 '13, 5:50 a.m.

Related questions

Custom attributes and the Reportable REST API

0
Jon Agnew (81●2●3) | asked Nov 10 '11, 3:51 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR
We have an RTC workitem type with some custom attributes of type "Contributor" and would like to report on these attributes using Rational Insight, but cannot locate them.

In Insight, I've run the following query against the RTC work item data source (workitem301.xdc): 
SELECT * FROM "WORKITEM_CCM"."CustomAttr"
which seems to correspond with allExtensions in RTC:
https://server:port/ccm/rpt/repository/workitem?fields=workItem/workItem/allExtensions/*

It returns custom attributes of type small/medium/large string, integer, etc, but not of type Contributor. Is there a way to access these custom "Contributor" attributes via the Reportable REST API (https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI), or is there another way to load them into Insight?

We're using RTC 3.0.1.

Thanks,
Jon

5 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Rafik Jaouani (5.0k●1●6) | answered Feb 26 '12, 6:34 p.m.
JAZZ DEVELOPER
Currently the reportable REST API only supports simple custom attributes.
BTW, if you use ?metadata=schema, you will see the supported schema.
1
permanent link
Jon Agnew (81●2●3) | answered Feb 27 '12, 9:07 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR
Hello, Any luck in finding an answer for this, i am facing the same issue

Hello, as Rafik noted, this is not currently supported. FYI, there is an enhancement request (Enhancement 184675). In the enhancement discussion thread there's a potential workaround offered, but it did not meet our needs.
Comments
Stephane Leroy commented Jun 18 '13, 4:54 a.m. | edited Jun 18 '13, 5:50 a.m.
JAZZ DEVELOPER

Status of Enhancement 184675 shows it was delivered in 4.0.3.
You might want to try out (have not done it myself -yet-)

Regards,
Stéphane

0
permanent link
Aziz Sharafi (16●1●3●2) | answered Feb 26 '12, 10:19 a.m.
We have an RTC workitem type with some custom attributes of type "Contributor" and would like to report on these attributes using Rational Insight, but cannot locate them.

In Insight, I've run the following query against the RTC work item data source (workitem301.xdc): 
SELECT * FROM "WORKITEM_CCM"."CustomAttr"
which seems to correspond with allExtensions in RTC:
https://server:port/ccm/rpt/repository/workitem?fields=workItem/workItem/allExtensions/*

It returns custom attributes of type small/medium/large string, integer, etc, but not of type Contributor. Is there a way to access these custom "Contributor" attributes via the Reportable REST API (https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI), or is there another way to load them into Insight?

We're using RTC 3.0.1.

Thanks,
Jon
0
permanent link
Aziz Sharafi (16●1●3●2) | answered Feb 26 '12, 10:19 a.m.
Hello, Any luck in finding an answer for this, i am facing the same issue


We have an RTC workitem type with some custom attributes of type "Contributor" and would like to report on these attributes using Rational Insight, but cannot locate them.

In Insight, I've run the following query against the RTC work item data source (workitem301.xdc): 
SELECT * FROM "WORKITEM_CCM"."CustomAttr"
which seems to correspond with allExtensions in RTC:
https://server:port/ccm/rpt/repository/workitem?fields=workItem/workItem/allExtensions/*

It returns custom attributes of type small/medium/large string, integer, etc, but not of type Contributor. Is there a way to access these custom "Contributor" attributes via the Reportable REST API (https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI), or is there another way to load them into Insight?

We're using RTC 3.0.1.

Thanks,
Jon
0
permanent link
Aziz Sharafi (16●1●3●2) | answered Feb 27 '12, 2:21 p.m.
Hello, Any luck in finding an answer for this, i am facing the same issue

Hello, as Rafik noted, this is not currently supported. FYI, there is an enhancement request (Enhancement 184675). In the enhancement discussion thread there's a potential workaround offered, but it did not meet our needs.


Thanks for the info, I will develop a plugin which copies the value from contributor field to another field of type string.. At least this will bring the data to insight.

Thanks

Your answer

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