It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×10,826

question asked: Jul 29 '11, 4:06 a.m.
question was seen: 4,667 times
last updated: Jul 29 '11, 4:06 a.m.

Related questions

FAQ - How this Forum works

The fastest way to get find work items?

0
Arkadiusz Kołodziejski (14●3●5) | asked 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

One answer

Most liked answers|Newest answers ↑|Oldest answers

0
permanent link
Aaron LaBella (51●4●3) | answered 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

Your answer

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