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

Is it possible to create queries during runtime using Plan Java client

Questions
Tags
Users
Badges
Karthik Krishnan
(909●19●130●170) edited
Mar 07 '13, 5:11 a.m.
I tried executing the (Thanks to @Rschoon for pointers) shared and personal queries 
Now I want to create query during run time, example I want to query with given ID
I am wondering if it's possible to create Queries during runtime via the Plain Java API client.




0 votes

1 answer
8,493 views
0 votes

Accepted answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) Mar 07 '13, 2:06 p.m.
 Hi Karthik,

As far as I know you can create a query from an expression. See http://rsjazz.wordpress.com/2012/11/19/using-expressions-for-automation/ and you can also save it. There are also some useful comments on the post above or that hat post: http://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
Karthik Krishnan selected this answer as the correct answer

0 votes

Comments
Karthik Krishnan
Mar 08 '13, 9:51 a.m.
 Thanks Ralph, one question though In your example (http://rsjazz.wordpress.com/2012/11/19/using-expressions-for-automation/ ), how can I get the WorkItemTypeID ?  Assuming I want to take all defects, how can I find this ID?  I believe this ID is the Type ID

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 08 '13, 10:06 a.m.
Hi, you look it up in the process configuration of the project. If you have something like the display name, you would have to use the API to get all available work item types in the API and iterate them to compare the display name with the string you have. 

Karthik Krishnan
Mar 08 '13, 11:01 a.m.
Thanks Ralph. What I need is to query work items of type "Issue" using the Expressions

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 08 '13, 11:15 a.m.
It should be easy enough to open the project area, go to the process configuration tab, find the Configuration Data>Work Items section, select Types and Attributes, select the issue work item and look up the type name like in the picture below. This depends on the process template you use.

1 vote

Karthik Krishnan
Mar 08 '13, 11:31 a.m.
 Thanks Ralph. I was trying this programatically with the help of https://jazz.net/forum/questions/93841/how-to-get-workitems-list-of-specific-type Now after your reply, I am able to get it working. Many thanks for your time & help

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 08 '13, 11:57 a.m.
Glad you got it working.

showing 5 of 6 show 1 more comments

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.

Ask a question
Guidelines
FAQ
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
× 11,109
× 419
× 170

Question asked: Mar 07 '13, 5:10 a.m.

Question was seen: 8,493 times

Last updated: Mar 08 '13, 11:57 a.m.

Confirmation Cancel Confirm