WSS 3.0 – Valid properties to be used in FullText Query Search in Search.asmx


When we have valid SQL query something like ““Select Category from Scope()”  and execute them using FullText Query Search in WSS 3.0 using Search Web Service, it throws “InvalidPropertyException”.  This confirms that not all the properties can be used in WSS Full Text search.  How do we know which are all the properties that can be used in WSS 3.0 Search?  Can this be found using SharePoint object model ?   Unfortunately the answer is No.  However,  there are 89 valid properties that can be used in SQL FullText query Search. Usage of any other properties other than these will throw invalid property exception. Here is the list of 89 properties (some of them are not relevant for WSS) however specifying those properties in the query don’t throw any error.


 
























































































































AboutMe


AccountName


Assistant


Authority


Birthday


CachedPath


CollapsingStatus


Company


ContentSource


Created


DataSource


DatePictureTaken


Department


DisplayTitle


DocSignature


DottedLine


EndDate


Fax


FileExtension


HighConfidenceDisplayProperty1


HighConfidenceDisplayProperty10


HighConfidenceDisplayProperty11


HighConfidenceDisplayProperty12


HighConfidenceDisplayProperty13


HighConfidenceDisplayProperty14


HighConfidenceDisplayProperty15


HighConfidenceDisplayProperty2


HighConfidenceDisplayProperty3


HighConfidenceDisplayProperty4


HighConfidenceDisplayProperty5


HighConfidenceDisplayProperty6


HighConfidenceDisplayProperty7


HighConfidenceDisplayProperty8


HighConfidenceDisplayProperty9


HighConfidenceImageURL


HighConfidenceMatching


HighConfidenceResultType


HireDate


HitHighlightedProperties


HitHighlightedSummary


HomePhone


Interests


IsDocument


JobTitle


LastModifiedTime


Location


Manager


MemberOf


MobilePhone


MySiteWizard


objectid


OfficeNumber


PastProjects


Peers


PersonalSpace


PictureThumbnailURL


PictureURL


PreferredName


ProxyAddresses


PublicSiteRedirect


Rank


RankDetail


Responsibilities


Schools


SID


SipAddress


SiteName


SiteTitle


Size


Skills


StartDate


urn:schemas.microsoft.com:


fulltextqueryinfo:cataloggroup


urn:schemas.microsoft.com:


fulltextqueryinfo:sourcegroup


urn:schemas-microsoft-com:


office:office#Description


urn:schemas-microsoft-com:office:office#ows_CrawlType


urn:schemas-microsoft-com:


office:office#ows_ListTemplate


urn:schemas-microsoft-com:


office:office#Subject


urn:schemas-microsoft-com:


office:office#Title


urn:schemas-microsoft-com:


publishing:Category


urn:schemas-microsoft-com:


publishing:CategoryTitle


urn:schemas-microsoft-com:sharepoint:portal:area:


CategoryUrlNavi


urn:schemas-microsoft-com:sharepoint:portal:area:Path


UserName


UserProfile_GUID


WebId


WebSite


WorkEmail


WorkId


WorkPhone