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
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
fulltextqueryinfo:sourcegroup
urn:schemas-microsoft-com:
office:office#Description
urn:schemas-microsoft-com:office:office#ows_CrawlType
office:office#ows_ListTemplate
office:office#Subject
office:office#Title
publishing:Category
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
PingBack from http://informationsfunnywallpaper.cn/?p=2008
i am able to create catalog but unable to set as default fulltext catalog.