CQWP Filtering on empty field

Question

We've a ToDo list with tasks. New tasks are not assigned.

We would like to use a CQWP and add a filter showing only Unassigned Tasks.The value of the Assigned To field would be empty.

Adding a filter  (Custom Value option) for empty fields, doesn't work:

error: Please specify one of the following [PageFieldValue: (field name)] or [PageQueryString: (query string parameter name)] or an integer value for setting up a dynamic date range for date fields.

Leaving the custom value empty; adding Null; 0 or Blank doesn't work and result in the notification shown above.

How to get this filter work???

Answer 1

Hi KWJ- filtering on null isn't supported for that. As a workaround, I would create a calculated column (or use a workflow) to set a new field with something (like a 1) if assigned to is blank. Then query based off that field instead.

---

cameron rautmann

Answer 2

Hi KWJ,

I agreed with croute1, please check if his reply is useful for you. If yes, please remember to mark it as answer, it will be beneficial to others in this forum who meet the same issue in the future.

Best Regards,

Wendy

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact [e-mail]

Answer 3

I hope to check this out during next 2 weeks, Ï have to finish some more important things first  [next couple of months I'm recovering from surgery..]