New answers tagged view
Management of public views requires the Manage List permission. You can create a custom permission level or use one of the out-of-the-box permission levels that includes the Manage List permission: Full Control, Design, Manage Hierarchy are a few Keep in mind that Manage List also enables users to manage list columns or delete the list altogether
I was able to implement this by using a customized View as with PirateEric's comment, but I needed to group the conditions in a way the GUI list view filter editor wouldn't let me. The solution involved using SP Designer 2010 to edit the CAML query for the filter directly. I figured out the query using the CAML Query Helper tool on CodePlex: ...
You don't need a calculated column to do this. Simply go to your tasks list and create a new view. Expand the filter section and add Status is not equal to Completed AND Modified is greater than [Today] - 3. You can optionally expand the item limit section to return a max number of items.
Create a calculated field with the following formula : =IF([Status]<>'Completed';true;IF(DateDiff([Now],[Modified])>3;false;true)) and then use the created column to filter your items; regards.
For now I'm using a built-in column that all lists inherit from the Item content type. It's the LinkTitle. It's a calculated field that automatically adds the correct content type in the querystring, so it solves my problem.
Top 50 recent answers are included