Product DocsMenu

Coveo Platform 7.0 >
User Help > More Advanced Search > Available System Fields

Available System Fields

System fields are common to most repositories. The following sections provide tables listing some of the available fields for various systems and repositories.

Notes:

  • Field aliases exist for more common fields that may also be used by end-users (see Available Field Aliases).

  • The content of some fields such as @sysauthor and @systitle sometimes are not filled with valid information when for example, authors create a document from a template and omit to change the template metadata values.

This topic contains the following sections:

Tip: The names of the standard repository-specific Coveo fields for some repositories are prefixed to more easily identify their origin. A reference topic exists for each standard field so that you can use the online help search to list available fields as presented in the following table.

Repository type Prefix Query to list reference topics for related fields
Confluence sysCF

@title="syscf*" field @audience="Developer"

Microsoft Dynamics

sysCRM

@title="syscrm*" field @audience="Developer"

Desktop sysDESKTOP

@title="sysdesktop*" field @audience="Developer"

Jive/SBS/Clearspace sysCS

@title="syscs*" field @audience="Developer"

Salesforce sysSF

@title="syssf*" field @audience="Developer"

SharePoint sysSP

@title="syssp*" field @audience="Developer"

Coveo System Fields

The following table lists the available Coveo system fields.

Name Type Description Example
sysaboutme String Contains the description of the user. @sysaboutme=manager

Finds users whose description contains the word manager.

sysaddeddate Date/time Contains the date at which the document was first added to the index. @sysaddeddate=today

Finds documents added to the index today.

sysauthor String Contains the author of the document. @sysauthor=John

Finds documents whose author is John.

sysauthorloginname String Contains the login name of the document author. @sysauthorloginname=
COVEO\JSmith

Finds documents whose author login name is COVEO\JSmith.

syscollection String Contains the name of the collection in which the document is indexed. @syscollection=Coveo

Finds documents from the Coveo collection.

sysconcepts String

Contains the key concepts extracted at indexation time by the CES linguistic algorithm to create the document excerpt and summary that consist of noun phrases [noun and its modifiers (if any), e.g., president of the company] that best represent the content of the document.

Note: The CES linguistic algorithm behind the field does not distinguish hyphenated words, meaning that two similar hyphenated words may appear in the @sysconcepts field of a search result.

Example: one-way loop and one-way-loop.

If the two similar hyphenated words appear in two different search results, the facets and ranking code take their similarity into account and merge both results.

@sysconcepts=stemming

Finds documents for which CES has extracted the concept stemming.

syscontainsattachment String Indicates if the document contains attachments (email attachments or files in an archive such as a .zip or .rar). @syscontainsattachments

Finds documents containing attachments.

sysdate Date/time Contains the date on which the document was last modified or the creation date for a new document.

Note: The indexing date of a document is indicated by sysaddeddate; whereas, its re-indexing, refreshing or rebuilding date is indicated by sysindexeddate.

@sysdate=today

Finds documents created or modified today.

@sysdate>now-5h

Finds documents created or modified less than 5 hours ago.

sysdocumenttype

String

CES 7.0.7711+ (June 2015) Contains the type of the document as specified in the original (source) repository.

@sysdocumenttype=video

Finds video documents.

sysduration Floating Point Contains the duration, in seconds, of the audio video document. @sysduration>120

Finds audio video documents whose duration exceeds 120 seconds.

sysfilename String Contains the filename of the document. @sysfilename=Online_Documentation

Finds documents whose file names contain Online_Documentation.

sysfiletype String Contains the document type (see Supported File Formats). @sysfiletype=doc

Finds Microsoft Word documents.

sysfirstname String Contains the first name of the user. @sysfirstname=John

Finds user whose first name is John.

sysheight Numeric Contains the height of the picture. @sysheight>512

Finds pictures whose height is greater than 512 pixels.

sysindexeddate Date/time

Contains the most recent date on which the document was re-indexed, refreshed or rebuilt.

Notes:

  • The indexing date of a document is indicated by sysaddeddate; whereas, its modification date by sysdate.
  • The @sysindexeddate field can be set by the index, crawlers, and even custom conversion scripts, and may therefore not be the most accurate to find when documents where last indexed. The @sysrowid field indicates the order in which documents are indexed and can be used to sort documents in ascending or descending order.
@sysindexeddate<today-30d

Finds documents indexed more than a month ago.

sysisattachment String Indicates if the document is an attachment (email attachments or files in an archive such as .zip or .rar). @sysisattachment

Finds email attachments and archive files (ex.: files in a .zip archive).

sysisreference String Indicates if the document is indexed by reference. @sysisreference

Finds documents indexed by reference.

not @sysisreference

Finds documents indexed by content.

syslanguage String Contains the language of the document (see Supported Languages). @syslanguage=Spanish

Finds documents written in Spanish.

not @syslanguage

Finds documents whose language is unknown.

syslastname String Contains the last name of the user. @syslastname=Smith

Finds users whose last name is Smith.

sysloginname String Contains the login name of the user. @sysloginname = COVEO\JSmith

Finds users whose login name is COVEO\JSmith.

sysmonth String Contains the month of the modification date of the document (from 01 to 12). @sysmonth=09

Finds documents created or modified in September.

sysoffice String Contains the location of the office of the user. @sysoffice=Boston

Finds users whose office is located in Boston.

syspages Numeric Contains the number of pages of the document. @syspages>100

Finds documents containing more than 100 pages.

syspicturetakenon Date/Time Contains the date on which the picture was taken. @syspicturetakenon=today

Finds pictures taken today.

sysrelatedlink String Contains the related (or alternate) link of the document. @sysrelatedlink=Coveo

Finds documents whose related links contain Coveo.

syssite String Contains the website address of the document. @syssite=www.coveo.com

Finds documents located on the Coveo website.

syssize Numeric Contains the size, in bytes, of the document. @syssize>1024

Finds documents whose size is larger than 1 K B.

syssource String Contains the source in which the document is indexed. @syssource=Coveo

Finds documents from the Coveo source.

syssourcetype
String

CES 7.0.7711+ (June 2015) Contains the type of the source used to index the document.

@syssourcetype=YouTube

Finds YouTube source documents.

systitle String Contains the title of the document. @systitle=Coveo

Finds documents whose titles contain the word Coveo.

sysuri String Contains the URI of the document. @sysuri=Coveo

Finds documents whose URI contain the word Coveo.

syswidth Numeric Contains the width of the picture. @syswidth>512

Finds pictures whose width is greater than 512 pixels.

sysworkemail String Contains the work email of the user. @sysworkemail=coveo@search.com

Finds users who have the following work email: coveo@search.com.

sysworktitle String Contains the work title of the user. @sysworktitle=manager

Finds users whose title contains manager.

sysyear String Contains the document creation or modification year. @sysyear=2010

Finds documents created or modified in 2010.

Microsoft SharePoint Fields

The following table lists the available fields in CES for Microsoft SharePoint content.

Name Type Description Example
sysspblogpostid String Contains the blog post ID of the SharePoint blog comment. @sysspblogpostid=2

Finds SharePoint blog comments whose ID is 2.

sysspcontenttype String Contains the content type of the SharePoint item or document. @sysspcontenttype=post

Finds SharePoint items and documents whose content type is post.

sysspiscontainer String Indicates if the SharePoint item is a container (portal, site, or list). @sysspiscontainer

Finds SharePoint containers items (portals, sites, lists, etc.).

sysspisdraft String Indicates whether the SharePoint item or document is a draft. @sysspisdraft

Finds SharePoint items and documents that are drafts.

sysspispersonalsite String Indicates if the SharePoint item is a personal site. @sysspispersonalsite

Finds SharePoint personal sites.

sysspistoplevelsite String Indicates if the SharePoint item is a top-level site. @sysspistoplevelsite

Finds SharePoint top-level sites.

sysspitemtype String Contains the type of the SharePoint item or document (site, list, list item, etc [see Available Item Types]). @sysspitemtype=list item

Finds all SharePoint items and documents.

syssplistbasetype String Contains the list base type of the SharePoint item or document (document library, issues, discussion, etc [see Available List Base Types]). @syssplistbasetype= documentlibrary

Finds all SharePoint documents whose list base type is documentlibrary.

syssplistitemid String Contains the ID of the SharePoint list item or document. @syssplistitemid = 2

Finds SharePoint items and documents whose list item ID is 2.

syssplistname String Contains the list name of the SharePoint item or document. @syssplistname=Coveo

Finds SharePoint items or documents whose list name contains Coveo.

syssplisttype String Contains the list type of the SharePoint item or document. @syssplisttype=Agenda

Finds SharePoint items and documents whose list type is Agenda.

syssprelativelisturi String Contains the relative part of the list URI of the SharePoint item or document. @syssprelativelisturi=document

Finds SharePoint items and documents whose relative list URIs contain document.

sysspsitename String Contains the site name of the SharePoint item or document. @sysspsitename="Coveo Enterprise Search - Technical Support"

Finds SharePoint items and documents whose site title contains the expression Coveo Enterprise Search - Technical Support.

sysspsiteuri String Contains the site URI of the SharePoint item or document. @sysspsiteuri=support

Finds SharePoint items and documents whose site URI contains support.

sysspversion String Contains the SharePoint version of the SharePoint item or document (2007 or 2010). @sysspversion=2007

Finds SharePoint items or documents whose SharePoint versions are 2007 (WSS 3.0 and MOSS 2007).

Microsoft Exchange Fields

The following table lists the available fields in CES originating from Microsoft Exchange servers.

Name Type Description Example
sysbcc String Contains the BCC (blind carbon copy) recipients of the email. @sysbcc=John

Finds emails whose BCC recipient contains John.

syscc String Contains the CC (carbon copy) recipients of the email. @syscc=John

Finds emails whose CC recipient contains John.

sysconversationtopic String Contains the conversation thread of the email. The conversation thread includes the initial email and all other messages sharing the same title such as replies and forwards. @sysconversationtopic="New Product"

Finds emails in the New Product thread.

sysdisplaycc String Contains the displayed name of the CC recipients of the email. @sysdisplaycc=John

Finds emails for which the CC recipient display name contains John.

sysdisplayfrom String Contains the displayed name of the sender of the email. @sysdisplayfrom=John

Finds emails whose sender display name contains John.

sysdisplayrecipients String Contains the displayed name of the recipients and CC recipients of the email. @sysdisplayrecipients=John

Finds emails whose recipients or CC recipients display name contains John.

sysdisplayto String Contains the displayed name of the recipients of the email. @sysdisplayto=John

Finds emails whose recipients display name contains John.

sysemailfolders String Contains the parent folder names of the Exchange item. @sysemailfolders=Support

Finds Exchange items whose parent folder name contains Support.

sysfrom String Contains the sender of the email. @sysfrom=John

Finds emails whose sender contains John.

sysisdeleteditem String Indicates if the Exchange item is in the Deleted Items folder. @sysisdeleteditem

Finds Exchange items located in the Deleted Items folder.

sysmailbox String Contains the mailbox name of the Exchange item. @sysmailbox=Coveo

Finds Exchange items whose mailbox name contain Coveo.

sysrecipients String Contains the recipients and CC recipients of the email. @sysrecipients=John

Finds emails whose recipients or CC recipients contain John.

syssubject String Contains the subject of the Exchange item. @syssubject=Products

Finds Exchange items whose subject contains the word Products.

systo String Contains the recipients of the email. @systo=John

Finds emails whose recipient contains John.

Salesforce Fields

The following table lists the available fields in CES for Salesforce content.

Name Metadata Type
syssfaccount SFAccount String
syssfaccountid SFAccountID String
syssfamount SFAmount Floating point
syssfamountconverted SFAmountConverted Floating point
syssfbillingcity SFBillingCity String
syssfbillingcountry SFBillingCountry String
syssfbillingpostalcode SFBillingPostalCode String
syssfbillingstate SFBillingState String
syssfbillingstreet SFBillingStreet String
syssfCaseBugNumbers bugnumbers String
syssfCaseCallStacks callstacks String
syssfCaseHasBugs hasbugs String
syssfcaseid SFCaseID String
syssfcasenumber sfcasenumber String
syssfcity SFCity String
syssfclosedate SFCloseDate Date/time
syssfclosedatebucket SFCloseDateBucket String
syssfcloseddate sfcloseddate Date/time
syssfclosequarter SFCloseQuarter String
syssfcompany SFCompany String
syssfcontact sfcontact String
syssfcountry SFCountry String
syssfcreatedby SFCreatedBy String
syssfcreatedbyID SFCreatedByID String
syssfcreateddate SFCreatedDate Date/time
syssfcreateddatebucket SFCreatedDateBucket String
syssfcurrency SFCurrency String
syssfcurrentpriority SFCurrentPriority Numeric
syssfdescription SFDescription String
syssfduration SFDuration Numeric
syssfemail SFEmail String
syssffax SFFax String
syssffirstname SFFirstName String
syssfid SFId String
syssfindustry SFIndustry String
syssflastname SFLastName String
syssfleadsource SFLeadSource String
syssflocation SFLocation String
syssfOpenDate opendate Date/time
syssfopportunityType SFOpportunityType String
syssfowner SFOwner String
syssfownerid SFOwnerID String
syssfparents syssfparents String
syssfphone SFPhone String
syssfpostalcode SFPostalCode String
syssfpricebandid SFPriceBandId String
syssfpricebandname SFPriceBandName String
syssfpriority SFPriority String
syssfproducts syssfproducts String
syssfshippingcity SFShippingCity String
syssfshippingcountry SFShippingCountry String
syssfshippingpostalcode SFShippingPostalCode String
syssfshippingstate SFShippingState String
syssfshippingstreet SFShippingStreet String
syssfstagename SFStageName String
syssfstate SFState String
syssfstatus SFStatus String
syssfstreet SFStreet String
syssfwebsite SFWebSite String
People who viewed this topic also viewed