Query Work Items with dc:description

[joycelynteo]

query_str = ('dc:type="defect"' and '"word" in dc:description')

Is there a way I can query work items that have a certain word in its description? Something like the line above. If it's not possible, is there a way to increase the query limit from 1000 because I would like more data for work items that have the word in the description.

[dixudx]

query_str = ('dc:type="defect"' and '"word" in dc:description')

It seems '"word" in dc:description' is not supported, refer to the query syntax for more details,

query      ::= (term (boolean_op term)*)+ modifiers
term       ::= (identifier operator)? value+ | (identifier "in")? in_val
operator   ::= "=" | "!=" | "<" | ">" | "<=" | ">="
boolean_op ::= "and"
modifiers  ::= sort?
sort       ::= "/sort" "=" identifier
identifier ::= word (":" word)?

Is there a way I can query work items that have a certain word in its description?

AFAIK, we can only filter those items after querying.

is there a way to increase the query limit from 1000

We can use sort to help sort top 1000 items and use dc:created to help filter later 1000 items and so on.

query_str = 'dc:type="defect" and oslc:orderBY="dc:created"'

Use the creating time of last item in the query results for later queries, such as,

query_str = 'dc:type="defect" and dc:created>="12-02-2019T18:42:30" and oslc:orderBY="dc:created"'

[joycelynteo]

ah okay, thanks for your help!

[joycelynteo]

/sort="dc:created" doesn't seem to work for me, is that an issue on my side? The picture above appears in the url in the error "requests.exceptions.HTTPError: 400 Client Error: Bad Request for url:"

[dixudx]

@joycelynteo Please try query_str = 'dc:type="defect" and oslc:orderBY="dc:created"'.

Let me know if this works.

[joycelynteo]

It gives the same error

[dixudx]

@joycelynteo Please checkout branch query-order to see whether it works.

By default, the query results are sorted with descending order by last modified time. A new param order_by is added to method queryWorkitems. Possible value could be,

• "-dc:modified": descending order by last modified time
• "+dc:modified": assending order by last modified time
• "-dc:created": descending order by created time
• "+dc:created": assending order by created time
• "-rtc_cm:resolved": descending order by resolved time
• "+rtc_cm:resolved": assending order by resolved time