Wednesday, 2 May 2012

SharePoint 2007: Manage Item Scheduling does not work

When “Manage item scheduling” doesn’t work, in a sharepoint list items or news pages \, that are queried with a Content Query Webpart:

Work Around:

Go to the Parent Content type page.
Create a new property ("Add new site column") to your content type.
Name the property Hidden (type yes/no checkbox). Make sure the property will be inherited by all content types.
Name the property & choose type:


Make sure the default value is "No", and that will be inherited:


Create or use an existing date field (ex: Article Date)
Add 2 new query filters to your CQWP (image below)
AND ArticleDate is “less or equal than”
AND Hidden equals No


IMPORTANT: You might experience the problem that when you create the field Hidden, it will be empty for all existing items in the list. For that you can run a script in the SharePoint server to change a field value (see article “Change SharePoint List Field Value script”).

No comments: