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.

 Hi


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,
Dani

Accepted answer


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

 Have you looked at the Reportable Rest API? https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI#workitem

Dani Simon selected this answer as the correct answer

Comments
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/id=com.ibm.team.workitem.workItemType.defect and state/id!=com.ibm.team.workitem.defectWorkflow.state.done 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.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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 https://jazz.net/jazz/oslc/queries/{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.