Home > Appendices > Table of Filter Conditions
Export to PDFThe sections below contain the detailed information of all filter conditions.
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].
| Rule | Condition | Example | Result |
|---|---|---|---|
| URL | Contains | sitecollection | The site collection whose URL contains sitecollection is searched. Search result example: http://test:20000/sites/sitecollectionA |
| URL | Equals | http://test:20000/sites/sitecollectionA | The site collection whose URL is http://test:20000/sites/sitecollectionA is searched. |
| URL | Matches | http://tes*collec-tionA | The site collection whose URL begins with http://tes and ends with collectionA is searched. Search result example: http://tesABC:11111/sitecollectionA |
| URL | Matches | http://test:20000/sites/sitecollecti?nA | The 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 Title | Contains | title | The site collection whose title contains title is searched.Search result example: titleA and title1 |
| Site Collection Title | Equals | title1 | The site collection whose title is title1 is searched. |
| Site Collection Title | Matches | ti*1 | The site collection whose title begins with ti and ends with 1 is searched. Search result example: title1 |
| Site Collection Title | Matches | tit?e1 | The 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 Time | From…To | 2011-11-11 12:15:50 2011-12-25 17:35:54 | The site collection that is modified between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched. |
| Modified Time | Before | 2011-11-11 12:15:50 | The site collection that is modified before 12:15:50 11/11/2011 is searched. |
| Modified Time | After | 2011-11-11 12:15:50 | The site collection that is modified after 12:15:50 11/11/2011 is searched. |
| Modified Time | On | 2011-11-11 | The site collection that is modified on 11/11/2011 is searched. |
| Modified Time | Within days/weeks/months/years | 5 Days | The site collection that is modified in the last 5 days is searched. |
| Created Time | From…To | 2011-11-11 12:15:50 2011-12-25 17:35:54 | The site collection that is created between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched. |
| Created Time | Before | 2011-11-11 12:15:50 | The site collection that is created before 12:15:50 11/11/2011 is searched. |
| Created Time | After | 2011-11-11 12:15:50 | The site collection that is created after 12:15:50 11/11/2011 is searched. |
| Created Time | On | 2011-11-11 | The site collection that is created on 11/11/2011 is searched. |
| Created Time | Within days/weeks/months/years | 5 Days | The site collection that is created in the last 5 days is searched. |
| Level | Rule | Condition | Example |
|---|---|---|---|
| URL | Contains | siteA | The 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 |
| URL | Equals | http://test:20000/sites/sitecollectionA/siteA | The site whose URL is http://test:20000/sites/sitecollectionA/siteA is searched. |
| URL | Matches | http://tes*siteA | The site whose URL begins with http://tes and ends with siteA is searched. Search results example: http://tesABC:11111/site-collectionA/siteA |
| URL | Matches | http://test:20000/sites/sitecollection?/siteA | The 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 Title | Contains | title | The site whose title contains title is searched. Search result example: titleA and title1 |
| Site Title | Equals | title1 | The site whose title is title1 is searched. |
| Site Title | Matches | ti*1 | The site whose title begins with ti and ends with 1 is searched. Search result example: title1 |
| Site Title | Matches | tit?e1 | The site whose title is the same as tit?e1 except character ? is searched. Search result example: titAe1 |
| Modified Time | From…To | 2011-11-11 12:15:50 2011-12-25 17:35:54 | The site that is modified between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched. |
| Modified Time | Before | 2011-11-11 12:15:50 | The site that is modified before 12:15:50 11/11/2011 is searched. |
| Modified Time | After | 2011-11-11 12:15:50 | The site that is modified after 12:15:50 11/11/2011 is searched. |
| Modified Time | On | 2011-11-11 | The site that is modified on 11/11/2011 is searched. |
| Modified Time | Within days/weeks/months/years | 5 Days | The site that is modified in the last 5 days is searched. |
| Created Time | From…To | 2011-11-11 12:15:50 2011-12-25 17:35:54 | The site that is created between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched. |
| Created Time | Before | 2011-11-11 12:15:50 | The site that is created before 12:15:50 11/11/2011 is searched. |
| Created Time | After | 2011-11-11 12:15:50 | The site that is created after 12:15:50 11/11/2011 is searched. |
| Created Time | On | 2011-11-11 | The site that is created on 11/11/2011 is searched. |
| Created Time | Within days/weeks/months/years | 5 Days | The site that is created in the last 5 days is searched. |
| Inheritance | Equals | Inherited Permission | The site that has inherited permission from its parent node is searched. |
| Inheritance | Equals | Explicit Permissions | The site that has explicit permission is searched. |
| Level | Rule | Condition | Example |
|---|---|---|---|
| URL | Contains | libraryA | The library whose URL contains libraryA is searched. Search result example: http://test:20000/sites/sitecollectionA/siteA/LibraryA |
| URL | Equals | http://test:20000/sites/sitecollectionA/siteA/LibraryA | The library whose URL is http://test:20000/sites/site-collectionA/siteA/libraryA is searched. |
| URL | Matches | http://test:20000/*/LibraryA | The library whose URL begins with http://test:20000/ and ends with LibraryA is searched. Search result example: http://test:20000/sites/sitecollectionA/siteA/LibraryA |
| URL | Matches | http://te?t:20000/sites/sitecollectionA/siteA/LibraryA | The 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. |
| Name | Contains | lib | The library whose name contains lib will be searched out. For example, libraryA and lib123 are searched. |
| Name | Equals | libraryA | The library whose name is libraryA is searched. |
| Name | Matches | li*A | The library whose name begins with li and ends with A is searched. Search result example: libraryA |
| Name | Matches | libra?yA | The library whose name is the same as libra?yA except character ? is searched. Search results example: libraryA |
| Modified Time | From…To | 2011-11-11 12:15:50 2011-12-25 17:35:54 | The list/library that is modified between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched. |
| Modified Time | Before | 2011-11-11 12:15:50 | The list/library that is modified before 12:15:50 11/11/2011 is searched. |
| Modified Time | After | 2011-11-11 12:15:50 | The list/library that is modified after 12:15:50 11/11/2011 is searched. |
| Modified Time | On | 2011-11-11 | The list/library that is modified on 11/11/2011 is searched. |
| Modified Time | Within days/weeks/months/years | 5 Days | The list/library that is modified in the last 5 days is searched. |
| Created Time | From…To | 2011-11-11 12:15:50 2011-12-25 17:35:54 | The list/library that is created between 12:15:50 11/11/2011 and 17:35:54 12/25/2011 is searched. |
| Created Time | Before | 2011-11-11 12:15:50 | The list/library that is created before 12:15:50 11/11/2011 is searched. |
| Created Time | After | 2011-11-11 12:15:50 | The list/library that is created after 12:15:50 11/11/2011 is searched. |
| Created Time | On | 2011-11-11 | The list/library that is created on 11/11/2011 is searched. |
| Created Time | Within days/weeks/months/years | 5 Days | The list/library that is created in the last 5 days is searched. |
| Inheritance | Equals | Inherited Permission | The list/library that has inherited permission from its parent node is searched. |
| Inheritance | Equals | Explicit Permissions | The list/library that has explicated permission is searched. |
| Versioning | Equals | Enabled | The list/library with Versioning enabled is searched. |
| Versioning | Equals | Disabled | The list/library with Versioning disabled is searched. |
| Require Check Out | Equals | Yes | The list/library that is configured to require documents to be checked out before they can be edited is searched. |
| Require Check Out | Equals | No | The list/library that is not configured to require documents to be checked out before they can be edited is searched. |
| Level | Rule | Condition | Example |
|---|---|---|---|
| Name | Contains | folder | The folder whose name contains folder is searched. |
| Name | Equals | folderA | The folder whose name is folderA is searched. |
| Name | Matches | fol*A | The folder whose name begins with fol and ends with A is searched. |
| Name | Matches | fold?rA | The folder whose name is the same as fold?rA except character ? is searched. Search results example: folderA |
| Inheritance | Equals | Inherited Permission | The folder that has inherited permission from its parent node is searched. |
| Inheritance | Equals | Explicit Permissions | The folder that has explicated permission is searched. |
| Level | Rule | Condition | Example |
|---|---|---|---|
| Name | Contains | item | The item whose name contains item is searched. |
| Name | Equals | itemA | The item whose name is itemA is searched. |
| Name | Matches | it*A | The item whose name begins with it and ends with A is searched. Search result example: itemA |
| Name | Matches | ite?A | The item whose name is the same as ite?A except character ? is searched. Search result example: itemA |
| Versions | Only Latest [] Versions | 3 | The item’s last 3 versions are searched. |
| Versions | Only Latest [] Major Versions | 3 | The item’s last 3 major versions are searched. |
| Versions | Only Major Versions | N/A | All major versions are searched. |
| Versions | Only Approved Versions | N/A | All approved versions are searched. |
| Column: Text | Contains | test | The item that has the specified Text type column and the column value contains test is searched. |
| Column: Text | Equals | test | The item that has the specified Text type column and the column value is test is searched. |
| Column: Text | Matches | test | The item that has the specified Text type column and the column value contains test is searched. Wildcards such as “*” and “?” are available. |
| Column: Number | >= | 5 | The item that has the specified Number type column and the column value is equal to or greater than 5 is searched. |
| Column: Number | <= | 5 | The item that has the specified Number type column and the column value is equal to or less than 5 is searched. |
| Column: Number | Equals | 5 | The item that has the specified Number type column and the column value is 5 is searched. |
| Column: Yes/No | Equals | Yes | The item that has the specified Yes/No type column and the column value is Yes is searched. |
| Column: Date and Time | Before | 11/11/2011 12:15 | The 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 Time | After | 11/11/2011 12:15 | The 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 Time | On | 11/11/2011 12:15 | The 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 Time | Within | 5 Days | The item that has the specified Date and Time type column and the column value is within 5 days is searched. |
| Column: Date and Time | Older Than | 5 Days | The item that has the specified Date and Time type column and the column value is older than 5 days is searched. |
| Inheritance | Equals | Inherited Permission | The item that has inherited permission from its parent node is searched. |
| Inheritance | Equals | Explicit Permissions | The item that has explicated permission is searched. |
| Content Type | Equals | typeA | The item whose content type is typeA is searched. |
| Level | Rule | Condition | Example |
|---|---|---|---|
| Document Name and Extension | Contains | demo | The document whose name or extension contains demo is searched. |
| Document Name and Extension | Equals | demo.doc | The document whose name is demo and extension is .doc is searched. |
| Document Name and Extension | Matches | dem*lsc | The document whose name or extension begins with dem and ends with lsc is searched. |
| Document Name and Extension | Matches | demo.x?sc | The document whose name is demo and extension begins with x and ends with sc is searched. |
| Versions | Only Latest [] Versions | 3 | The file’s last 3 versions are searched. |
| Versions | Only Latest [] Major Versions | 3 | The 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 |
| Versions | Only Major Versions | N/A | All major versions are searched. |
| Versions | Only Approved Versions | N/A | All approved versions are searched. |
| Column: Text | Contains | test | The document that has the specified Text type column and the column value contains test is searched. |
| Column: Text | Equals | test | The document that has the specified Text type column and the column value is test is searched. |
| Column: Text | Matches | test | The document that has the specified Text type column and the column value contains test is searched. Wildcards such as “*” and “?” are available. |
| Column: Number | >= | 5 | The document that has the specified Number type column and the column value is equal to or greater than 5 is searched. |
| Column: Number | <= | 5 | The document that has the specified Number type column and the column value is equal to or less than 5 is searched. |
| Column: Number | Equals | 5 | The document that has the specified Number type column and the column value is 5 is searched. |
| Column: Yes/No | Equals | Yes | The document that has the specified Yes/No type column and the column value is Yes is searched. |
| Column: Date and Time | Before | 11/11/2011 12:15 | The 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 Time | After | 11/11/2011 12:15 | The 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 Time | On | 11/11/2011 12:15 | The 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 Time | Within | 5 Days | The document that has the specified Date and Time type column and the column value is within 5 days is searched. |
| Column: Date and Time | Older Than | 5 Days | The document that has the specified Date and Time type column and the column value is older than 5 days is searched. |
| Size | >= | N/A | The document whose size is equal to or greater than the entered number is searched. |
| Size | <= | N/A | The document whose size is equal to or less than the entered number is searched. |
| Total Version Size | >= | N/A | The document whose total version size is equal to or greater than the entered number is searched. |
| Total Version Size | <= | N/A | The document whose total version size is equal to or less than the entered number is searched. |
| Inheritance | Equals | Inherited Permission | The document that has inherited permission from its parent node is searched. |
| Inheritance | Equals | Explicit Permissions | The document that has explicated permission is searched. |
| Content Type | Equals | typeA | The item whose content type is typeA is searched. |
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.
| Rule | Condition | Value | Permission | Query Mode | Result |
|---|---|---|---|---|---|
| User and Group | Equals | user | Search for any permission | Exact permission | The site collection whose user name is user is searched without regard to user’s permission. |
| User and Group | Equals | user | Search for any permission | Exact permission or better | The site collection whose user name is user is searched without regard to user’s permission. |
| User and Group | Equals | user | Administrator(only available for Site Collection level) | Exact permission | The 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 Group | Equals | user | Administrator(only available for Site Collection level) | Exact permission or better | N/A |
| User and Group | Equals | user | Full Control | Exact permission | The site collection whose user name is user and whose user permission is Full Control is searched. |
| User and Group | Equals | user | Full Control | Exact permission or better | N/A |
| User and Group | Equals | user | Design | Exact permission | The site collection whose user name is user and whose user permission is Design is searched. |
| User and Group | Equals | user | Design | Exact permission or better | The site collection whose user name is user and whose user permission is equal or better than Design is searched. |
| User and Group | Equals | user | Contribute | Exact permission | The site collection whose user name is user and whose user permission is Contribute is searched. |
| User and Group | Equals | user | Contribute | Exact permission or better | The site collection whose user name is user and whose user permission is equal or better than Contribute is searched. |
| User and Group | Equals | user | Read | Exact permission | The site collection whose user name is user and whose user permission is Read is searched. |
| User and Group | Equals | user | Read | Exact permission or better | The site collection whose user name is user and whose user permission is equal or better than Read is searched. |
| User and Group | Equals | user | View Only | Exact permission | The site collection whose user name is user and whose user permission is View Only is searched. |
| User and Group | Equals | user | View Only | Exact permission or better | The site collection whose user name is user and whose user permission is equal or better than View Only is searched. |
| User and Group | Equals | user | Limited Access | Exact permission | The site collection whose user name is user and whose user permission is Limited Access is searched. |
| User and Group | Equals | user | Limited Access | Exact permission or better | The site collection whose user name is user and whose user permission is equal or better than Limited Access is searched. |