The fastest way to get find work items?

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&#40;Operator.AND&#41;;

termAnd.add&#40;projectAreaExpression&#41;;

termAnd.add&#40;customAttributeExpression&#41;;

                          ....

IQueryResult&lt;IResolvedResult&lt;IWorkItem&gt;&gt; results = null;

results = qClient.getResolvedExpressionResults&#40;

this.currentProjectArea, termAnd, IWorkItem.SMALL_PROFILE&#41;;

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

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&#40;Operator.AND&#41;;

termAnd.add&#40;projectAreaExpression&#41;;

termAnd.add&#40;customAttributeExpression&#41;;

                          ....

IQueryResult&lt;IResolvedResult&lt;IWorkItem&gt;&gt; results = null;

results = qClient.getResolvedExpressionResults&#40;

this.currentProjectArea, termAnd, IWorkItem.SMALL_PROFILE&#41;;
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

It's all about the answers!

Related questions

The fastest way to get find work items?

One answer

Your answer