It's all about the answers!

Ask a question

Querying the queries


Sandeep Singh (111) | asked Jun 28 '13, 8:17 p.m.
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

One answer



permanent link
Ralph Schoon (62.7k33643) | answered Jul 01 '13, 2:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.

Your answer


Register or to post your answer.