Menu
Cutty
  • Chryslers
  • Lutherie
  • YLSNED
  • About
Cutty

SharePoint filters evaluate criteria in order

Posted on September 23, 2010February 19, 2015 by Iain 'Cutty' Carlin

Users requested that I filter a list of announcements so that the logic would work like:

(Show All Users Notices OR Staff Notices) AND (Posted before today AND expire after today).

The default filtering doesn’t let you put the brackets into the filter query. Turns out that SharePoint runs the query in order and ‘virtually’ puts brackets around things.

So my eventual logic was(((Show all Users Notices Or Staff Notices) AND StartDate before Today) AND Expires After Today).

  • SharePoint
  • Recent Posts

    • Books I read in 2025
    • 2024 was the best year for our solar system
    • Books I read in 2024
    • Books I read in 2023
    • Happy New Year 2024

    Categories

    • Chryslers (1)
    • Cutty's Blog (13)
    • Lutherie (38)
    • You Learn Something New Every Day (44)
    ©2026 Cutty | Powered by Superb Themes