It's all about the answers!

Ask a question

[RTC EWM] I want to get the list of created queries using API.


HIROAKI JOSAKO (47427) | asked Jun 07 '21, 3:41 a.m.

I think we create and use it every day.
I want to get the name and URL of that shared query.
Ideally it can be obtained using the REST API.
It is intended to automate exports and remove randomly created unwanted queries.

I am waiting for your idea.

Thanks

Accepted answer


permanent link
Ralph Schoon (63.1k33645) | answered Jun 07 '21, 7:00 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Jun 07 '21, 7:10 a.m.

 Please see: https://jazz.net/wiki/bin/view/Main/ResourceOrientedWorkItemAPIv2#Using_Stored_Queries



The headers you use decide if you get the queries just by link, or get the queries with more information.

As an example Accept:text/xml has worked best for me. 

Request GET https://elm.example.com:9443/ccm/oslc/queries/_MV9ncHHZEeuKHaIVR_wUnA/rtc_cm:results
Request Headers
    Accept text/xml; charset=utf-8
    

HIROAKI JOSAKO selected this answer as the correct answer

Comments
Ralph Schoon commented Jun 07 '21, 7:04 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

HIROAKI JOSAKO commented Jun 24 '21, 5:02 a.m.

Hi Ralph
Thanks example code
I tried to get the list with this code but it didn't work.

Request GET https://elm.example.com:9443/ccm/oslc/queries.xml?oslc_cm.query=rtc_cm%3AprojectArea%3D%22_8e5qfFpmEeukW7cqqDjAuA%22

I specified a project area, but all the server queries are retrieved.
 


HIROAKI JOSAKO commented Jun 24 '21, 5:05 a.m.

Sorry!!
I tried it again and it worked! !!
That was a really big help.

Thanks!


Ralph Schoon commented Jun 24 '21, 6:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I found various cases, where my query was incorrect and I got every query back, instead an error.


HIROAKI JOSAKO commented Jun 25 '21, 2:46 a.m.

That was exactly right.
When I mistyped this part, I was getting all the queries on the Server.

oslc_cm.query = rtc_cm: projectArea =

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.