Managed Properties in FAST vs. SharePoint 2010
In SharePoint 2010 the FAST Query SSA has its own set of managed properties out of the box, which is independent of those in the SharePoint SSA. Customers often wonder how these properties are different. Here we examine all the out of the box properties of each and their differences.
SharePoint
To get a list of all managed properties for the SharePoint SSA, run the following script in a SharePoint PowerShell:
#$ssa=A reference to the SharePoint SSA
Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication $ssa | Select Name, Managedtype
This gives us the following list of 126 managed properties.
AboutMe |
Text |
Account |
Text |
AccountName |
Text |
AssignedTo |
Text |
Author |
Text |
BaseOfficeLocation |
Text |
BestBetKeywords |
Text |
CategoryNavigationUrl |
Text |
CollapsingStatus |
Integer |
Colleagues |
Text |
contentclass |
Text |
ContentsHidden |
Text |
ContentSource |
Text |
ContentType |
Text |
CreatedBy |
Text |
Department |
Text |
Description |
Text |
DisplayDate |
DateTime |
DocComments |
Text |
DocId |
Text |
DocKeywords |
Text |
DocSignature |
Text |
DocSubject |
Text |
DuplicateHash |
Integer |
Text |
|
EndDate |
DateTime |
ExcludeFromSummary |
Text |
ExpirationTime |
DateTime |
FileExtension |
Text |
Filename |
Text |
FirstName |
Text |
FollowAllAnchor |
Text |
HierarchyUrl |
Text |
HighConfidenceDisplayProperty1 |
Text |
HighConfidenceDisplayProperty10 |
Text |
HighConfidenceDisplayProperty11 |
Text |
HighConfidenceDisplayProperty12 |
Text |
HighConfidenceDisplayProperty13 |
Text |
HighConfidenceDisplayProperty14 |
Text |
HighConfidenceDisplayProperty15 |
Text |
HighConfidenceDisplayProperty2 |
Text |
HighConfidenceDisplayProperty3 |
Text |
HighConfidenceDisplayProperty4 |
Text |
HighConfidenceDisplayProperty5 |
Text |
HighConfidenceDisplayProperty6 |
Text |
HighConfidenceDisplayProperty7 |
Text |
HighConfidenceDisplayProperty8 |
Text |
HighConfidenceDisplayProperty9 |
Text |
HighConfidenceImageURL |
Text |
HighConfidenceMatching |
Text |
HighConfidenceResultType |
Text |
HitHighlightedProperties |
Text |
HitHighlightedSummary |
Text |
HostingPartition |
Text |
ImageDateCreated |
DateTime |
Interests |
Text |
IsDocument |
YesNo |
JobTitle |
Text |
Keywords |
Text |
LastModifiedTime |
DateTime |
LastName |
Text |
Location |
Text |
Memberships |
Text |
MetadataAuthor |
Text |
MobilePhone |
Text |
ModifiedBy |
Text |
NLCodePage |
Integer |
Notes |
Text |
OfficeNumber |
Text |
OrgNames |
Text |
OrgParentNames |
Text |
OrgParentUrls |
Text |
OrgUrls |
Text |
OWS_URL |
Text |
parentLink |
Text |
PastProjects |
Text |
Path |
Text |
PictureHeight |
Integer |
PictureThumbnailURL |
Text |
PictureURL |
Text |
PictureWidth |
Integer |
PreferredName |
Text |
Priority |
Text |
PrivateColleagues |
Text |
Pronunciations |
Text |
Purpose |
Text |
Rank |
Integer |
RankDetail |
Text |
RankingWeightHigh |
Text |
RankingWeightLow |
Text |
RankingWeightName |
Text |
Responsibilities |
Text |
Schools |
Text |
SecondaryFileExtension |
Text |
ServerRedirectedURL |
Text |
ServiceApplicationID |
Text |
SipAddress |
Text |
Site |
Text |
SiteID |
Text |
SiteTitle |
Text |
Size |
Integer |
Skills |
Text |
SocialTagTextUrl |
Text |
SPSiteURL |
Text |
StartDate |
DateTime |
Status |
Text |
Title |
Text |
UrlDepth |
Integer |
urn:schemas.microsoft.com:fulltextqueryinfo:cataloggroup |
Text |
urn:schemas.microsoft.com:fulltextqueryinfo:sourcegroup |
Text |
urn:schemas-microsoft-com:office:office#Description |
Text |
urn:schemas-microsoft-com:office:office#ows_CrawlType |
Text |
urn:schemas-microsoft-com:office:office#ows_ListTemplate |
Text |
urn:schemas-microsoft-com:office:office#Subject |
Text |
urn:schemas-microsoft-com:office:office#Title |
Text |
urn:schemas-microsoft-com:publishing:Category |
Text |
urn:schemas-microsoft-com:publishing:CategoryTitle |
Text |
urn:schemas-microsoft-com:sharepoint:portal:area:CategoryUrlNavi |
Text |
urn:schemas-microsoft-com:sharepoint:portal:area:Path |
Text |
UserName |
Text |
UserProfile_GUID |
Text |
WebId |
Text |
WikiCategory |
Text |
WorkEmail |
Text |
WorkPhone |
Text |
YomiDisplayName |
Text |
FAST Search
To get a list of all managed properties for the FAST Query SSA, run the following script in a FAST PowerShell on the FAST server:
Get-FASTSearchMetadataManagedProperty | Select Name, Type | Sort-Object Name | Format-Table
This gives us the following list of 102 managed properties:
Account |
Text |
anchortext |
Text |
AssignedTo |
Text |
assocqueries |
Text |
Author |
Text |
body |
Text |
charset |
Text |
CollapsingStatus |
Integer |
Companies |
Text |
Company |
Text |
companyteaser |
Text |
contentclass |
Text |
Contents |
Text |
ContentSource |
Text |
ContentType |
Text |
crawledpropertiescontent |
Text |
crawledpropertynames |
Text |
Created |
Datetime |
CreatedBy |
Text |
description |
Text |
DetectedLanguage |
Text |
DisplayDate |
Datetime |
docacl |
Text |
docaclsystemid |
Text |
DocComments |
Text |
docdatetime |
Datetime |
DocKeywords |
Text |
docrank |
Integer |
DocSubject |
Text |
documentsignature |
Integer |
docvector |
Text |
domain |
Text |
eetitle |
Text |
EndDate |
Datetime |
fileextension |
Text |
Filename |
Text |
FilterMetaData |
Integer |
format |
Text |
HitHighlightedProperties |
Text |
HitHighlightedSummary |
Text |
hwboost |
Integer |
ImageDateCreated |
Datetime |
IsDocument |
Boolean |
IsEmptyList |
Boolean |
IsListItem |
Boolean |
JobTitle |
Text |
Keywords |
Text |
language |
Text |
languages |
Text |
Location |
Text |
locations |
Text |
locationteaser |
Text |
MetadataAuthor |
Text |
MobilePhone |
Text |
ModifiedBy |
Text |
notes |
Text |
OrgNames |
Text |
OWSItemURL |
Text |
owsmetadatafacetinfo |
Text |
owsSPLocationInfo |
Text |
owstaxid |
Text |
owstaxidmetadataalltagsinfo |
Text |
owstaxIdSPLocationInfo |
Text |
owstaxIdSPLocationList |
Text |
owstaxIdSPLocationSite |
Text |
OWSURL |
Text |
Path |
Text |
personnames |
Text |
personnameteaser |
Text |
PictureHeight |
Integer |
PictureThumbnailURL |
Text |
PictureWidth |
Integer |
Priority |
Text |
processingtime |
Datetime |
Purpose |
Text |
SchemaSignature |
Integer |
ServerRedirectedURL |
Text |
Site |
Text |
SiteId |
Text |
SiteName |
Text |
siterank |
Integer |
SiteTitle |
Text |
Size |
Integer |
sizelabel |
Text |
spdocid |
Text |
spsiteurl |
Text |
StartDate |
Datetime |
status |
Text |
teaser |
Text |
Title |
Text |
tld |
Text |
url |
Text |
urldepthrank |
Integer |
urlkeywords |
Text |
urls |
Text |
UserName |
Text |
WebId |
Text |
WikiCategory |
Text |
WorkEmail |
Text |
WorkId |
Integer |
WorkPhone |
Text |
Write |
Datetime |
Differences
So now we have a handy reference for all the managed properties. You'll notice not only that the FAST list is shorter, but there are actually a lot of changes. FAST drops and introduces quite a few of them. For a better look at how they are different, here is a Diff of the two, showing the change as you move from the SharePoint SSA to the FAST Query SSA.
Legend:
In SharePoint SSA but not FAST Query SSA
In both
New in FAST Query SSA
AboutMe
Account
AccountName
anchortext
AssignedTo
assocqueries
Author
BaseOfficeLocation
BestBetKeywords
CategoryNavigationUrl
body
charset
CollapsingStatus
Colleagues
Companies
Company
companyteaser
contentclass
ContentsHidden
Contents
ContentSource
ContentType
crawledpropertiescontent
crawledpropertynames
Created
CreatedBy
Department
Description
description
DetectedLanguage
DisplayDate
docacl
docaclsystemid
DocComments
DocId
docdatetime
DocKeywords
DocSignature
docrank
DocSubject
DuplicateHash
documentsignature
docvector
domain
eetitle
EndDate
ExcludeFromSummary
ExpirationTime
FileExtension
fileextension
Filename
FirstName
FollowAllAnchor
HierarchyUrl
HighConfidenceDisplayProperty1
HighConfidenceDisplayProperty10
HighConfidenceDisplayProperty11
HighConfidenceDisplayProperty12
HighConfidenceDisplayProperty13
HighConfidenceDisplayProperty14
HighConfidenceDisplayProperty15
HighConfidenceDisplayProperty2
HighConfidenceDisplayProperty3
HighConfidenceDisplayProperty4
HighConfidenceDisplayProperty5
HighConfidenceDisplayProperty6
HighConfidenceDisplayProperty7
HighConfidenceDisplayProperty8
HighConfidenceDisplayProperty9
HighConfidenceImageURL
HighConfidenceMatching
HighConfidenceResultType
FilterMetaData
format
HitHighlightedProperties
HitHighlightedSummary
HostingPartition
hwboost
ImageDateCreated
Interests
IsDocument
IsEmptyList
IsListItem
JobTitle
Keywords
LastModifiedTime
LastName
language
languages
Location
Memberships
locations
locationteaser
MetadataAuthor
MobilePhone
ModifiedBy
NLCodePage
Notes
OfficeNumber
notes
OrgNames
OrgParentNames
OrgParentUrls
OrgUrls
OWS_URL
parentLink
PastProjects
OWSItemURL
owsmetadatafacetinfo
owsSPLocationInfo
owstaxid
owstaxidmetadataalltagsinfo
owstaxIdSPLocationInfo
owstaxIdSPLocationList
owstaxIdSPLocationSite
OWSURL
Path
personnames
personnameteaser
PictureHeight
PictureThumbnailURL
PictureURL
PictureWidth
PreferredName
Priority
PrivateColleagues
Pronunciations
processingtime
Purpose
Rank
RankDetail
RankingWeightHigh
RankingWeightLow
RankingWeightName
Responsibilities
Schools
SecondaryFileExtension
SchemaSignature
ServerRedirectedURL
ServiceApplicationID
SipAddress
Site
SiteID
SiteId
SiteName
siterank
SiteTitle
Size
Skills
SocialTagTextUrl
SPSiteURL
sizelabel
spdocid
spsiteurl
StartDate
Status
status
teaser
Title
UrlDepth
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
tld
url
urldepthrank
urlkeywords
urls
UserName
UserProfile_GUID
WebId
WikiCategory
WorkEmail
WorkId
WorkPhone
YomiDisplayName
Write
Comments
- Anonymous
May 15, 2013
comment