It's all about the answers!

Ask a question

Fetch all RTC Defects for one project area filtering by status with OSLC / Rest API ?

Dani Simon (70114) | asked Jan 11 '21, 9:57 a.m.


Is it possible to get all RTC defects by oslc or rest api? And is it possible to filter them by status, too? 
I don't find anything and getting crazy, because I am sure this function must be available ... 

Thanks a lot,

Accepted answer

permanent link
Alex Akilov (663) | answered Jan 11 '21, 12:02 p.m.

 Have you looked at the Reportable Rest API?

Dani Simon selected this answer as the correct answer

Dani Simon commented Jan 12 '21, 5:30 a.m.

thank a lot, this was the hint I needed to get! 

I've solved it this way now:
https://server/ccm/rpt/repository/workitem?fields=workitem/workItem[type/ and state/id! and projectArea/name="ourProjName"]/(id|type/name|state/name|state/id|summary)

2 other answers

permanent link
David Honey (1.8k17) | answered Jan 11 '21, 2:37 p.m.

You might also look at OSLC query for work items.

permanent link
Jim Amsden (29337) | answered Jan 13 '21, 9:13 a.m.

 There are a number of ways:

1. Create a EWM stored query and getting the results using a URL such as{queryId}/rtc_cm:results. 

2. Use an OSLC query 

3. Create a JRS query with Report Builder and access the results using either the LQE SPARQL endpoint: https://{host}:{port}/lqe/sparql or the LQE datasrouce URL available from the Export as Microsoft Excel page.

4. Use the EWM reportable REST API.

I find the EWM stored query approach very easy and convenient. But I also use OSLC query and JRS report datasource URLs a lot too depending on what I'm trying to query.

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.