Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Querying the queries

Hi,
My requirement might sound strange.
But our project is using RTC since a long time and in Queries section lot of junk is stored now.
So I need to clean up Work Item query area, for which I am trying to find a way so that I can get:
-Query name, description, creator
-Last execution date etc

This metadata of queries will surely help me. But unfortunately I din't get any way to get it.
FYI I am using RTC 2.0.0.2

Appreciate if anyone can help !
Regards

0 votes



One answer

Permanent link
You would probably have to iterate all project areas similar to the code here: http://rsjazz.wordpress.com/2012/12/09/analyzing-a-aroject-areas-members-and-roles-using-the-plain-java-client-libraries/ and use the code here to get the shared queries http://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/.

I am not sure, if it is possible to get information about when a query has been run.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,016

Question asked: Jun 28 '13, 8:17 p.m.

Question was seen: 4,900 times

Last updated: Jul 01 '13, 2:55 a.m.

Confirmation Cancel Confirm