Home > Appendices > Table of Filter Conditions

Export to PDF

Table of Filter Conditions

The sections below contain the detailed information of all filter conditions.

NOTE

For custom columns, you may use either the column's display name or its internal name. When using the internal name, enclose it in brackets. For example: [InternalName].

Level - Site Collection

RuleConditionExampleResult
URLContainssitecollectionThe site collection whose URL contains sitecollection is searched. Search result example: http://test:20000/sites/sitecollectionA
URLEqualshttp://test:20000/sites/sitecollectionAThe site collection whose URL is http://test:20000/sites/sitecollectionA is searched.
URLMatcheshttp://tes*collec-tionAThe site collection whose URL begins with http://tes and ends with collectionA is searched. Search result example: http://tesABC:11111/sitecollectionA
URLMatcheshttp://test:20000/sites/sitecollecti?nAThe site collection whose URL is the same as http://test:20000/sites/sitecollecti?nA except character ? is searched. Search result example: http://test:20000/sites/sitecollectionA
Site Collection TitleContainstitleThe site collection whose title contains title is searched.Search result example: titleA and title1
Site Collection TitleEqualstitle1The site collection whose title is title1 is searched.
Site Collection TitleMatchesti*1The site collection whose title begins with ti and ends with 1 is searched. Search result example: title1
Site Collection TitleMatchestit?e1The site collection whose title is the same as tit?e1 except character ? is searched. The character ? represents any character. Search result example: titAe1 and titBe1
Modified TimeFrom…To2011-11-11 12:15:50 2011-12-25 17:35:54The site collection that is modified between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched.
Modified TimeBefore2011-11-11 12:15:50The site collection that is modified before 12:15:50 11/11/2011 is searched.
Modified TimeAfter2011-11-11 12:15:50The site collection that is modified after 12:15:50 11/11/2011 is searched.
Modified TimeOn2011-11-11The site collection that is modified on 11/11/2011 is searched.
Modified TimeWithin days/weeks/months/years5 DaysThe site collection that is modified in the last 5 days is searched.
Created TimeFrom…To2011-11-11 12:15:50 2011-12-25 17:35:54The site collection that is created between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched.
Created TimeBefore2011-11-11 12:15:50The site collection that is created before 12:15:50 11/11/2011 is searched.
Created TimeAfter2011-11-11 12:15:50The site collection that is created after 12:15:50 11/11/2011 is searched.
Created TimeOn2011-11-11The site collection that is created on 11/11/2011 is searched.
Created TimeWithin days/weeks/months/years5 DaysThe site collection that is created in the last 5 days is searched.

Level - Site

LevelRuleConditionExample
URLContainssiteAThe site whose URL contains siteA is searched. Search result example: http://test:20000/sites/site-collectionA/siteA and http://test:20000/sites/site-collectionA/siteAB
URLEqualshttp://test:20000/sites/sitecollectionA/siteAThe site whose URL is http://test:20000/sites/sitecollectionA/siteA is searched.
URLMatcheshttp://tes*siteAThe site whose URL begins with http://tes and ends with siteA is searched. Search results example: http://tesABC:11111/site-collectionA/siteA
URLMatcheshttp://test:20000/sites/sitecollection?/siteAThe site whose URL is the same as http://test:20000/sites/site-collection?/siteA except character ? is searched. Search result example: http://test:20000/sites/site-collectionA/siteA
Site TitleContainstitleThe site whose title contains title is searched. Search result example: titleA and title1
Site TitleEqualstitle1The site whose title is title1 is searched.
Site TitleMatchesti*1The site whose title begins with ti and ends with 1 is searched. Search result example: title1
Site TitleMatchestit?e1The site whose title is the same as tit?e1 except character ? is searched. Search result example: titAe1
Modified TimeFrom…To2011-11-11 12:15:50 2011-12-25 17:35:54The site that is modified between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched.
Modified TimeBefore2011-11-11 12:15:50The site that is modified before 12:15:50 11/11/2011 is searched.
Modified TimeAfter2011-11-11 12:15:50The site that is modified after 12:15:50 11/11/2011 is searched.
Modified TimeOn2011-11-11The site that is modified on 11/11/2011 is searched.
Modified TimeWithin days/weeks/months/years5 DaysThe site that is modified in the last 5 days is searched.
Created TimeFrom…To2011-11-11 12:15:50 2011-12-25 17:35:54The site that is created between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched.
Created TimeBefore2011-11-11 12:15:50The site that is created before 12:15:50 11/11/2011 is searched.
Created TimeAfter2011-11-11 12:15:50The site that is created after 12:15:50 11/11/2011 is searched.
Created TimeOn2011-11-11The site that is created on 11/11/2011 is searched.
Created TimeWithin days/weeks/months/years5 DaysThe site that is created in the last 5 days is searched.
InheritanceEqualsInherited PermissionThe site that has inherited permission from its parent node is searched.
InheritanceEqualsExplicit PermissionsThe site that has explicit permission is searched.

Level - List/Library

LevelRuleConditionExample
URLContainslibraryAThe library whose URL contains libraryA is searched. Search result example: http://test:20000/sites/sitecollectionA/siteA/LibraryA
URLEqualshttp://test:20000/sites/sitecollectionA/siteA/LibraryAThe library whose URL is http://test:20000/sites/site-collectionA/siteA/libraryA is searched.
URLMatcheshttp://test:20000/*/LibraryAThe library whose URL begins with http://test:20000/ and ends with LibraryA is searched. Search result example: http://test:20000/sites/sitecollectionA/siteA/LibraryA
URLMatcheshttp://te?t:20000/sites/sitecollectionA/siteA/LibraryAThe library whose URL is the same as http://te?t:20000/sites/sitecollectionA/siteA/LibraryA except character**?** is searched. Search result example: http://test:20000/sites/sitecollectionA/siteA/LibraryA.
NameContainslibThe library whose name contains lib will be searched out. For example, libraryA and lib123 are searched.
NameEqualslibraryAThe library whose name is libraryA is searched.
NameMatchesli*AThe library whose name begins with li and ends with A is searched. Search result example: libraryA
NameMatcheslibra?yAThe library whose name is the same as libra?yA except character ? is searched. Search results example: libraryA
Modified TimeFrom…To2011-11-11 12:15:50 2011-12-25 17:35:54The list/library that is modified between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched.
Modified TimeBefore2011-11-11 12:15:50The list/library that is modified before 12:15:50 11/11/2011 is searched.
Modified TimeAfter2011-11-11 12:15:50The list/library that is modified after 12:15:50 11/11/2011 is searched.
Modified TimeOn2011-11-11The list/library that is modified on 11/11/2011 is searched.
Modified TimeWithin days/weeks/months/years5 DaysThe list/library that is modified in the last 5 days is searched.
Created TimeFrom…To2011-11-11 12:15:50 2011-12-25 17:35:54The list/library that is created between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched.
Created TimeBefore2011-11-11 12:15:50The list/library that is created before 12:15:50 11/11/2011 is searched.
Created TimeAfter2011-11-11 12:15:50The list/library that is created after 12:15:50 11/11/2011 is searched.
Created TimeOn2011-11-11The list/library that is created on 11/11/2011 is searched.
Created TimeWithin days/weeks/months/years5 DaysThe list/library that is created in the last 5 days is searched.
InheritanceEqualsInherited PermissionThe list/library that has inherited permission from its parent node is searched.
InheritanceEqualsExplicit PermissionsThe list/library that has explicated permission is searched.
VersioningEqualsEnabledThe list/library with Versioning enabled is searched.
VersioningEqualsDisabledThe list/library with Versioning disabled is searched.
Require Check OutEqualsYesThe list/library that is configured to require documents to be checked out before they can be edited is searched.
Require Check OutEqualsNoThe list/library that is not configured to require documents to be checked out before they can be edited is searched.

Level - Folder

LevelRuleConditionExample
NameContainsfolderThe folder whose name contains folder is searched.
NameEqualsfolderAThe folder whose name is folderA is searched.
NameMatchesfol*AThe folder whose name begins with fol and ends with A is searched.
NameMatchesfold?rAThe folder whose name is the same as fold?rA except character ? is searched. Search results example: folderA
InheritanceEqualsInherited PermissionThe folder that has inherited permission from its parent node is searched.
InheritanceEqualsExplicit PermissionsThe folder that has explicated permission is searched.

Level - Item

LevelRuleConditionExample
NameContainsitemThe item whose name contains item is searched.
NameEqualsitemAThe item whose name is itemA is searched.
NameMatchesit*AThe item whose name begins with it and ends with A is searched. Search result example: itemA
NameMatchesite?AThe item whose name is the same as ite?A except character ? is searched. Search result example: itemA
VersionsOnly Latest [] Versions3The item’s last 3 versions are searched.
VersionsOnly Latest [] Major Versions3The item’s last 3 major versions are searched.
VersionsOnly Major VersionsN/AAll major versions are searched.
VersionsOnly Approved VersionsN/AAll approved versions are searched.
Column: TextContainstestThe item that has the specified Text type column and the column value contains test is searched.
Column: TextEqualstestThe item that has the specified Text type column and the column value is test is searched.
Column: TextMatchestestThe item that has the specified Text type column and the column value contains test is searched. Wildcards such as “*” and “?” are available.
Column: Number>=5The item that has the specified Number type column and the column value is equal to or greater than 5 is searched.
Column: Number<=5The item that has the specified Number type column and the column value is equal to or less than 5 is searched.
Column: NumberEquals5The item that has the specified Number type column and the column value is 5 is searched.
Column: Yes/NoEqualsYesThe item that has the specified Yes/No type column and the column value is Yes is searched.
Column: Date and TimeBefore11/11/2011 12:15The item that has the specified Date and Time type column and the column value is before 12:15 11/11/2011 is searched.
Column: Date and TimeAfter11/11/2011 12:15The item that has the specified Date and Time type column and the column value is after 12:15 11/11/2011 is searched.
Column: Date and TimeOn11/11/2011 12:15The item that has the specified Date and Time type column and the column value is 12:15 11/11/2011 is searched.
Column: Date and TimeWithin5 DaysThe item that has the specified Date and Time type column and the column value is within 5 days is searched.
Column: Date and TimeOlder Than5 DaysThe item that has the specified Date and Time type column and the column value is older than 5 days is searched.
InheritanceEqualsInherited PermissionThe item that has inherited permission from its parent node is searched.
InheritanceEqualsExplicit PermissionsThe item that has explicated permission is searched.
Content TypeEqualstypeAThe item whose content type is typeA is searched.

Level - Document

LevelRuleConditionExample
Document Name and ExtensionContainsdemoThe document whose name or extension contains demo is searched.
Document Name and ExtensionEqualsdemo.docThe document whose name is demo and extension is .doc is searched.
Document Name and ExtensionMatchesdem*lscThe document whose name or extension begins with dem and ends with lsc is searched.
Document Name and ExtensionMatchesdemo.x?scThe document whose name is demo and extension begins with x and ends with sc is searched.
VersionsOnly Latest [] Versions3The file’s last 3 versions are searched.
VersionsOnly Latest [] Major Versions3The file’s last 3 major versions are searched. If a file has the following versions: 1.0, 2.0, 2.1, 2.2, 3.0, 3.1, the search result example is: version 1.0, 2.0, 3.0
VersionsOnly Major VersionsN/AAll major versions are searched.
VersionsOnly Approved VersionsN/AAll approved versions are searched.
Column: TextContainstestThe document that has the specified Text type column and the column value contains test is searched.
Column: TextEqualstestThe document that has the specified Text type column and the column value is test is searched.
Column: TextMatchestestThe document that has the specified Text type column and the column value contains test is searched. Wildcards such as “*” and “?” are available.
Column: Number>=5The document that has the specified Number type column and the column value is equal to or greater than 5 is searched.
Column: Number<=5The document that has the specified Number type column and the column value is equal to or less than 5 is searched.
Column: NumberEquals5The document that has the specified Number type column and the column value is 5 is searched.
Column: Yes/NoEqualsYesThe document that has the specified Yes/No type column and the column value is Yes is searched.
Column: Date and TimeBefore11/11/2011 12:15The document that has the specified Date and Time type column, and the column value is before 12:15 11/11/2011 is searched.
Column: Date and TimeAfter11/11/2011 12:15The document that has the specified Date and Time type column and the column value is after 12:15 11/11/2011 is searched.
Column: Date and TimeOn11/11/2011 12:15The document that has the specified Date and Time type column and the column value is 12:15 11/11/2011 is searched.
Column: Date and TimeWithin5 DaysThe document that has the specified Date and Time type column and the column value is within 5 days is searched.
Column: Date and TimeOlder Than5 DaysThe document that has the specified Date and Time type column and the column value is older than 5 days is searched.
Size>=N/AThe document whose size is equal to or greater than the entered number is searched.
Size<=N/AThe document whose size is equal to or less than the entered number is searched.
Total Version Size>=N/AThe document whose total version size is equal to or greater than the entered number is searched.
Total Version Size<=N/AThe document whose total version size is equal to or less than the entered number is searched.
InheritanceEqualsInherited PermissionThe document that has inherited permission from its parent node is searched.
InheritanceEqualsExplicit PermissionsThe document that has explicated permission is searched.
Content TypeEqualstypeAThe item whose content type is typeA is searched.

User and Group

The table below contains detailed information on the User and Group filter condition. The filter rules are similar across levels like Site Collection, Site, List/Library, Folder, Item, and Document.

RuleConditionValuePermissionQuery ModeResult
User and GroupEqualsuserSearch for any permissionExact permissionThe site collection whose user name is user is searched without regard to user’s permission.
User and GroupEqualsuserSearch for any permissionExact permission or betterThe site collection whose user name is user is searched without regard to user’s permission.
User and GroupEqualsuserAdministrator(only available for Site Collection level)Exact permissionThe site collection whose user name is user and is a member of the Site Collection Administrators group of the site collection is searched.
User and GroupEqualsuserAdministrator(only available for Site Collection level)Exact permission or betterN/A
User and GroupEqualsuserFull ControlExact permissionThe site collection whose user name is user and whose user permission is Full Control is searched.
User and GroupEqualsuserFull ControlExact permission or betterN/A
User and GroupEqualsuserDesignExact permissionThe site collection whose user name is user and whose user permission is Design is searched.
User and GroupEqualsuserDesignExact permission or betterThe site collection whose user name is user and whose user permission is equal or better than Design is searched.
User and GroupEqualsuserContributeExact permissionThe site collection whose user name is user and whose user permission is Contribute is searched.
User and GroupEqualsuserContributeExact permission or betterThe site collection whose user name is user and whose user permission is equal or better than Contribute is searched.
User and GroupEqualsuserReadExact permissionThe site collection whose user name is user and whose user permission is Read is searched.
User and GroupEqualsuserReadExact permission or betterThe site collection whose user name is user and whose user permission is equal or better than Read is searched.
User and GroupEqualsuserView OnlyExact permissionThe site collection whose user name is user and whose user permission is View Only is searched.
User and GroupEqualsuserView OnlyExact permission or betterThe site collection whose user name is user and whose user permission is equal or better than View Only is searched.
User and GroupEqualsuserLimited AccessExact permissionThe site collection whose user name is user and whose user permission is Limited Access is searched.
User and GroupEqualsuserLimited AccessExact permission or betterThe site collection whose user name is user and whose user permission is equal or better than Limited Access is searched.