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

How to Fetch all WI of Specific Type,having Same Attribute Value Using Reportable Rest API

Questions
Tags
Users
Badges
jyoti mishra
(45●1●48) edited
Feb 20 '21, 6:15 a.m.

 Hello,


I want to fetch the result of all the task WI having custom Attribute named as 'Count' value is less then or equal to '8'..Kindly provide the query to achieve this and also this WI should be from Same Project Area.I am able to get the response of all the WI having some 'count' value ,but not able to filter it.

Thanks and Regards,
Jyoti

0 votes

1 answer
3,885 views
0 votes

One answer

Permanent link
Ian Wark
(797●1●35●53) Feb 25 '21, 2:35 a.m.
There are different APIs. Here is one way..

I use a browser REST client extension such as "RESTClient". Log in normally and then open the REST client in a separate tab.

Add these two Headers:
OSLC-Core-Version: 2.0
Accept: application/rdf+xml

You need to find your URL for workitems services. Use this tip to get it from your ccm rootservices document. That gives you your base URL.


For me it is:

Then you need to build the oslc.where clause on to it and specify the 8 value for your Count attribute.

https://jazz.ibm.com:9443/ccm/oslc/contexts/_po_k4VYHEeu3JKQfbezR9w/workitems?oslc.where=dcterms:Count="8"

0 votes

Comments
Ian Wark
Feb 25 '21, 4:06 a.m.
And to add the Task work items filter, this worked for me: https://jazz.ibm.com:9443/ccm/oslc/contexts/_po_k4VYHEeu3JKQfbezR9w/workitems?oslc.where=dcterms:Count="8" and dcterms:type="task" The "and" is a bit unexpected, but the document mentions using it and it seems to work. In the final URL it has to be URL encoded with %20 before and after the "and". The RESTClient does that bit automatically.

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
× 7,622
× 1,452

Question asked: Feb 20 '21, 6:15 a.m.

Question was seen: 3,885 times

Last updated: Feb 25 '21, 4:06 a.m.

Confirmation Cancel Confirm