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.

 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 (663) | 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.8k17) | 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 (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 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.


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.