Posts

Showing posts with the label Lists

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...

List Types and Base Types

Here's a good reference that I've been using for the all the List Types and BaseTypes:

Email Enabled Lists

After lots of digging, I finally got incoming-email-to-list functionality working in MOSS. Take a look at Steve Smith's excellent tutorial on getting things set up here . I had several issues during my setup, but here are the highlights: Get things configured first using a machine-name/sub-domain first (i.e. use email@servername.company.com instead of email@company.com) The MS least-privilege configuration doesn't apply here - each web application with lists that you want to be email-enabled must use the same app-pool identity as Central Administration (i.e. the "farm account" ). Note that you can (and should) still have separate app-pools, but they have to run using the same identity. Don't forget to delegate control to the app-pool identity for making changes in AD. After getting frustrated I just granted full-control to the OU and then went back later and fixed it. Make sure the Sharepoint Timer service is running, otherwise the emails will just sit in the ...