Query on Description field in RTC

1	V Niranjan (125●4●49●72) \| asked Dec 10 '13, 7:53 p.m. Hi How do I create a query on Description field of a Work Item in RTC if it is BLANK. Regards Niranjan

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Kim Soederhamn (1.5k●2●41●44) | answered Dec 11 '13, 9:19 a.m.

Since you can only query on full text and with the condition "contains" I really dont see that to be possible. You can't sort on description either I believe.

What I would suggest is this:
1) make sure the description field is mandatory on certain states (you can do this on the operational behavior in the process configuration

2) to find all work items that are currently missing the description you can either query all workitems and export to csv.

3) If this doesn't work for you I would submit a workitem requestion a feature for searching for empty fields.

Comments

V Niranjan commented Dec 11 '13, 10:29 p.m.

Hi Kim

Thanks. I did think of the above responses but looks like it may not work.

We have recently moved away from CSV file usage and since there are around 1000 Work Item's querying on it and checking manually will be bit of tedious task.

Anyway looks like it may not be possible. Thanks a lot.

Regards
Niranjan V

It's all about the answers!

Related questions

Query on Description field in RTC

One answer

Your answer