Share via


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

EMail

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

Email

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