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 |