Posts

Showing posts from June, 2009

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

SharePoint gets a minus

A while back I created several page layouts for my company so that we would have a standard format for pages, news stories, etc. We really hadn't had any problems until one of our news stories had a '+' in it's title, and thus the suggested filename had a '+' in it. Apparently you are allowed to create a page with the special character '+' in it, but it will break your page. The behavior we saw was that you could see all the page content in edit mode, but none of it would show up when it was checked in/published. Also, there was some odd rendering of the page in edit mode. I was scratching my head over this for a while and pretty much randomly stumbled onto the solution. In the future, I'd suggest removing any non alpha-numeric characters from file names just to be safe, even though SharePoint doesn't warn you or remove them.