Advanced List View Filtering
The filter section of views is limited at best, and in some cases it is just wrong. For example if you have a list and you want to filter based on this boolean expression: Expression 1 : ((Column1=A OR Column2=B) AND Column3=C) OR Column4=D you would think you could expand the expression (because list view filters don't have parentheses) to Expression 2 : Column4=D OR Column3=C AND Column1=A OR Column3=C AND Column2=B The SharePoint UI will group the expression in a different way, not based on the order of operations (often giving you empty results, and always giving you the wrong results) However, SharePoint designer allows you to modify the filter yourself (of course it's kind of a pain). Steps First make sure you've attempted to put your filter expression into view through the UI (this will place the appropriate columns in your Where clause so it will be easier to move things around. Open the list view page in SharePoint designer Find th...