SharePoint Gen

The official blog of Chandrasekar, Microsoft SharePoint PFE

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

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

  • Comments 2

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Leave a Comment
  • Please add 6 and 1 and type the answer here:
  • Post
Page 1 of 1 (2 items)