how to query work items with empty description field

Question

I'd like to know if there is a way to query work items with empty description field (or other text fields). I need to query across projects to identify process compliance issues.

Answer 1

You can't with standard work item queries, because the contents will contain an HTML base structure, but you could relatively easily construct a piece of powershell that uses the TFS Client Object Model to query the data and then something like the HTML Agility Pack to extract what text there may or may not be. If everything withing the body tag is basically whitespace, you can do what you want.

---

My blog: blog.jessehouwing.nl