0

Im using a CQWP and need to display all items that have a column that is empty. The column is a lookup but I've tried a normal (single line of text) column but cqwp shows no filtering for null or empty values.

Improve this question
2
  • Well, i guess you could try with 0;# as this is the equivalent to a empty lookup column.
    – Christoffer
    Dec 4, 2015 at 15:21
  • Tried equal 0;# but doesn't work :(
    – Orange Juice Jones
    Dec 4, 2015 at 16:19

2 Answers 2

Reset to default
0

Workaround - create new Calculated column "Display".

Formula should be: =IF(LEN(LookupCol)=0;"Yes";"No").

Eventually, make a filter based on Display column: Show items when Display is equal to Yes.

Improve this answer
0

To further Tomislav's answer, set the calculated column to return Yes/No:

=IF(LEN(LookupCol)=0,1,0)

Then filter the CQWP with Display = 1

Edit: This doesn't work because apparently the generated CAML Query always sets the field type to text for calculated columns, according to this: https://github.com/pnp/sp-dev-fx-webparts/issues/758

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.