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 (708) | 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 (662) | 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.4k17) | answered Jan 11 '21, 2:37 p.m.

You might also look at OSLC query for work items.

permanent link
Jim Amsden (26837) | 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.