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

The fastest way to get find work items?

Questions
Tags
Users
Badges
Arkadiusz Kołodziejski
(14●3●5) Jul 29 '11, 4:06 a.m.
Hi,
I Would like to ask about the fastest way to get work items from project area.

I have implemented solution with: 

Term termAnd = new Term(Operator.AND);

termAnd.add(projectAreaExpression);

termAnd.add(customAttributeExpression);

                          ....

IQueryResult<IResolvedResult<IWorkItem>> results = null;

results = qClient.getResolvedExpressionResults(

this.currentProjectArea, termAnd, IWorkItem.SMALL_PROFILE);


but this solution is too slow for me.

Is there any other (faster) solution ?

I think about execute stored query, but i don't know how to set a parameter.
For instance: (1)get stored query ,(2) set owner,(3)execute exuery


Arek

0 votes

1 answer
5,240 views
0 votes

One answer

Permanent link
Aaron LaBella
(51●4●3) Aug 06 '11, 8:06 p.m.
I'd try applying some better filters to the query... it should be relatively fast when you're not searching for all workitems within a project area for a custom attribute (which probably isn't indexed).

Hi,
I Would like to ask about the fastest way to get work items from project area.

I have implemented solution with: 

Term termAnd = new Term(Operator.AND);

termAnd.add(projectAreaExpression);

termAnd.add(customAttributeExpression);

                          ....

IQueryResult<IResolvedResult<IWorkItem>> results = null;

results = qClient.getResolvedExpressionResults(

this.currentProjectArea, termAnd, IWorkItem.SMALL_PROFILE);


but this solution is too slow for me.

Is there any other (faster) solution ?

I think about execute stored query, but i don't know how to set a parameter.
For instance: (1)get stored query ,(2) set owner,(3)execute exuery


Arek

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.

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
× 10,938

Question asked: Jul 29 '11, 4:06 a.m.

Question was seen: 5,240 times

Last updated: Jul 29 '11, 4:06 a.m.

Confirmation Cancel Confirm