It's all about the answers!

Ask a question

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)?


Ankita Jaiswal (132) | asked 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)"

Accepted answer


permanent link
Subramanya Prasad Pilar (3.7k14) | answered 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

Comments
Subramanya Prasad Pilar commented 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 commented Apr 22 '19, 7:13 a.m. | edited 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 to post your answer.