SharePoint 2010 “wildcard” search

Wildcard search was one thing which was very dearly missed in MOSS 2007 and WSS 3.0. SharePoint 2010 has introduced this functionality which is quite helpful. However, though with some caveats

So you perform a search and you do not get any results and you keep wondering what have you done wrong

You have to search for “Brian” and you enter the following to search and do not get any results

e.g. Bria (this will not return you results starting with “Bria”)

That is correct behaviour as Sharepoint supports wildcard search only if you append “ * ”at the end of your keyword

e.g. Bria* (this will return you all the results starting with “Bria”)

Wildcard searches can be used in property searches as well

e.g. Author:Bria* (this will return all results where Author starts with “Bria”)

Also, wildcards only work at the end of a search string,

A wildcard at the beginning of a string will not be recognized, so searching for

e.g. “*rian” (this will not return you any results)

MOSS Faceted Search

MOSS Faceted Search is a set of web parts that provide intuitive way to refine search results by category (facet).

  • The facets are implemented using SharePoint API and stored within native SharePoint METADATA store. The solution demonstrates following key features:
  • Grouping search results by facet
  • Displaying a total number of hits per facet value
  • Refining search results by facet value
  • Update of the facet menu based on refined search criteria
  • Displaying of the search criteria in a Bread Crumbs
  • Ability to exclude the chosen facet from the search criteria
  • Flexibility of the Faceted search configuration and its consistency with MOSS administration


Search for Office 2007 files on WSS

When a Microsoft Windows SharePoint Services 3.0 site collection is searched by the Windows SharePoint Services Search service, the following 2007 Microsoft Office document types are not indexed:

Microsoft Office Excel 2007 (.xlsx, .xlsm)
Microsoft Office PowerPoint 2007 (.pptx, .pptm)
Microsoft Office Word 2007 (.docx, .docm)

Ifilter for Office 2007 is not installed.


1.Download and Install Office 2007 Microsoft Filter Pack

2.Register the Ifilter on your SharePoint index server

Now, SharePoint search will return Office 2007 documents in search results

How to get the list of Managed Properties using code

using Microsoft.Office.Server;
using Microsoft.Office.Server.Administration;
using Microsoft.Office.Server.Search;
using Microsoft.Office.Server.Search.Administration;

namespace ConsoleApplication1
    class Program
        private static ServerContext serverContext = null;
        private static SearchContext searchContext = null;

        static void Main(string[] args)
            string sharedServiceName = "SharedServices";
            serverContext = ServerContext.GetContext(sharedServiceName);
            searchContext = SearchContext.GetContext(serverContext);

            Schema schema = new Schema(searchContext);
            foreach (ManagedProperty prop in schema.AllManagedProperties)