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

HIROAKI JOSAKO (47●3●26) | 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 (62.0k●3●36●43) | 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

Please also see https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/522500

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

Another form

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

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

Use https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/ with the Java API.

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 =

It's all about the answers!

Related questions

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

Accepted answer

Your answer