April 7, 2009
April 1, 2009
How to Search on Last Modified By field in SharePoint Advanced Search
If you are wondering why you are unable to find any search result for Last Modified By filed in Advanced Search of SharePoint then don’t worry, you are not alone. This is one of the bug which still exist in SharePoint 2007 Server Search engine. I have found a solution posted by Pritam Dhake ina SharePoint forum. I have used this solution and it works like a charm.
Here are the steps to manually hook the Last Modified By field to the creawled field.
- Open Central administration -> Shared Services -> SharedServices (X being the number of the shared services provider for the site you are creating a mapping) – > search settings -> metadata property mappings
- Click “Modifiedby” to edit the properties
- Make sure “Include values from all crawled properties mapped” is selected
- Click “add mapping” and select the “Office” category from the dropdown list.
- look for a property named “OFFICE:8” , click “OK”
- Click “add mapping” and select the “ows_Last_x0020_Modified(text)” from the ALL categories dropdown list, Click “OK”
- Make sure the box is checked “Allow this property to be used in scopes”, click “OK”
- Click on “Crawled Properties” link on the left side of the Shared Services Administration page.
- Click On the “Office” Category.
- The mapped property you just created should be listed in the “Mapped To” column of the Office:8(Text) category.
- Click on the Office:8(Text) category to view the properties.
- In the “name and information” section, you should see the “property Set ID:” value is ‘F29F85E0-4FF9-1068-AB91-08002B27B3D9‘ …This is very important!!!
- In the “Mappings to managed properties” section the managed property you edited in steps 2 – 7 should be listed.
- The box to “Include values for this property in the search index” should be checked.
- Click “OK” to exit this page.
- Open “Shared Services administration” -> “ShareservicesX” -> “Search Settings” -> “Content Sources and crawl schedules”
- Click on “Local Office SharePoint Server sites” to expand the dropdown list and select “Start full crawl”
- When the crawl has completed, navigate to the site collection -> click on the search tab.
- Select “Advanced Search”
- In the properties dropdown list select “Last Modified By“
- Select contains
- Enter a name that you know has added / edited a document
- Click the magnifier to execute the search
- Get back results.
