Very simple question, the list view dynamic filter (The one you see when you click on a column header), uses the OR operator for a multi-value field. However, I want to use the AND operator instead.

In other words, there are three items with a mult-value field.

  1. Chris, Jack, Joe
  2. Chris, Joe
  3. Chris

When I filter with Chris and Joe, I see all three (It filters Chris OR Joe)

However, I'd like to see only 1 and 2 (Filtering Chris AND Joe).

Any way how to do this?

I'm using SP 2013. I'm a developer so any (clientside) solution is fine.

  • Christoffel, You may need to create a web part or application page to allow for this flexibility. I'm still researching, but it's all I'm aware of thus far.
    – jpollar
    Feb 26, 2015 at 15:57
  • 1
    Similar post that may help. sharepoint.stackexchange.com/questions/88349/…
    – jpollar
    Feb 26, 2015 at 16:03
  • To your original answer: Sadly, not an option as this is for SharePoint Online. Feb 26, 2015 at 16:03
  • Did the link I sent you help at all?
    – jpollar
    Feb 26, 2015 at 16:30
  • Sort of, using REST is possible. Though I wish there would be an easier way of doing this. I've been trying to work with URL querystring manipulation, to add the field twice in the querystring with seperate values instead of the ;. Feb 26, 2015 at 18:45


Your Answer

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

Browse other questions tagged or ask your own question.