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

I want to construct a request or query using Reportable REST API to fetch the value of custom attribute of type Decimal (in all Extensions)?

Questions
Tags
Users
Badges
Ankita Jaiswal
(13●3) Apr 18 '19, 8:23 a.m.

 I have tried many ways but did not get teh output.

queryRestRequestString = "workItem/workItem[projectArea/name='" & CONST_projectName & "' and " & strPlannedType & " and timeSpent>0]/(id|type/name|summary|parent/id|parent/summary|creationDate|state/name|owner/name|target/name|duration|correctedEstimate|timeSpent|dueDate|category/name|bigDecimalExtensions[key='ar.sanofi.attribute.etc']/value)"

0 votes

1 answer
4,056 views
0 votes

Accepted answer

Permanent link
Subramanya Prasad Pilar
(4.6k●1●6) Apr 22 '19, 4:26 a.m.

I can see the folloding REST URL works fine:
https://clm605.rtp.raleigh.ibm.com:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[projectArea/name='JKE Banking (Change Management)' and target/name='Product Backlog']/(id|type/name|summary|parent/id|parent/summary|creationDate|state/name|owner/name|target/name|duration|correctedEstimate|timeSpent|dueDate|category/name|bigDecimalExtensions[key='sanofi']/value)

Note that there is no "&" in AND condition. Also note that filtering is not supported for some properties.

Ankita Jaiswal selected this answer as the correct answer

0 votes

Comments
Subramanya Prasad Pilar
Apr 22 '19, 4:27 a.m.
https://clm605.rtp.raleigh.ibm.com:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[projectArea/name='JKE Banking (Change Management)' and target/name='Product Backlog']/(id|type/name|summary|parent/id|parent/summary|creationDate|state/name|owner/name|target/name|duration|correctedEstimate|timeSpent|dueDate|category/name|bigDecimalExtensions[key='ar.sanofi.attribute.etc']/value) should work fine.

Ankita Jaiswal
Apr 22 '19, 7:16 a.m.
This works fine for me but only for newly created workitems. I am not able to fetch this decimal custom attribute in xml using this rest query for old workitems. The old workitems are having this attribute value and timeentries also. For old workitems, this allExtensions or bigDecimalExtensions xml tag is not coming in xml output.

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.

Ask a question
Guidelines
FAQ
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
× 11,106
× 1,736

Question asked: Apr 18 '19, 8:23 a.m.

Question was seen: 4,056 times

Last updated: Apr 22 '19, 7:16 a.m.

Confirmation Cancel Confirm