Home > Appendices > Filter Policies > SharePoint/OneDrive Filter Policies
Export to PDFThe following sections show the details about the supported filter rules of each object level. For each object level, you can configure multiple filter rules and define the relations of the rules. By default, the relation of filter rules is And, which means Fly will migrate the source data that meets all configured rules. You can also click And to change the relation to Or. Then, Fly will migrate the source data that meet any of the configured rules.
| Object level | Rule | Condition | Value | Relation | Result |
|---|---|---|---|---|---|
| Site collection | Template name | Equals | Blank Site | And | The site collection whose name is Site A and template name is Blank Site will be migrated. |
| Site collection | Title | Equals | Site A | And | The site collection whose name is Site A and template name is Blank Site will be migrated. |
| Site collection | Template name | Equals | Blank Site | Or | The site collection whose name is Site A or template name is Blank Site will be migrated. |
| Site collection | Title | Equals | Site A | Or | The site collection whose name is Site A or template name is Blank Site will be migrated. |
Only available for SharePoint Online Migration.
| Rule | Condition | Value | Result | Comment |
|---|---|---|---|---|
| URL | Contains | test | The site collection whose URL contains test will be migrated. For example, http://contoso.onmicrosoft.com/sites/test and http:// contoso.onmicrosoft.com/sites/testA will be migrated. | |
| URL | Does not contain | test | The site collection whose URL does not contain test will be migrated. For example, http:// contoso.onmicrosoft.com/AP will be migrated. | |
| URL | Equals | http://contoso.onmicrosoft.com/sites/test | The site collection whose URL is http://contoso.onmicrosoft.com/sites/test will be migrated. | |
| URL | Does not equal | http://contoso.onmicrosoft.com/sites/test | The site collection whose URL is not http://contoso.onmicrosoft.com/sites/test will be migrated. | |
| URL | Matches | |||
| (This filter rule is case sensitive.) | http://tes*collectionA | The site collection whose URL begins with http://tes and ends with collectionA will be migrated. For example, http://tescontoso.onmicrosoft.com/sitecollectionA will be migrated. | ||
| URL | Matches | |||
| (This filter rule is case sensitive.) | http://contoso.onmicrosoft.com/sites/sitecollecti?nA | The site collection whose URL is the same as http://contoso.onmicrosoft.com/sites/sitecollecti?nA except character ? will be migrated. For example, http://contoso.onmicrosoft.com/sites/sitecollectionA and http://contoso.onmicrosoft.com/sites/sitecollectiBnA will be migrated. | ||
| URL | Does not match | |||
| (This filter rule is case sensitive.) | http://tes*collectionA | All the site collections except those whose URLs begin with http://tes and end with collectionA will be migrated. For example, http://contoso1.onmicrosoft.com/sites/test will be migrated. | ||
| URL | Does not match | |||
| (This filter rule is case sensitive.) | http://contoso.onmicrosoft.com/sites/sitecollecti?nA | All the site collections except those whose URLs are the same as http://contoso1.onmicrosoft.com/sites/sitecollecti?nA except character ? will be migrated. For example, http://contoso.onmicrosoft.com/sites/test will be migrated. | ||
| Title | Contains | test | The site collection whose title contains test will be migrated. | |
| Title | Does not contain | test | The site collection whose title does not contain test will be migrated. | |
| Title | Equals | test | The site collection whose title is test will be migrated. | |
| Title | Does not equal | test | The site collection whose title is not test will be migrated. | |
| Title | Matches | |||
| (This filter rule is case sensitive.) | te*t | The site collection whose title begins with te and ends with t will be migrated. For example, teABct will be migrated. | ||
| Title | Matches | |||
| (This filter rule is case sensitive.) | te?t | The site collection whose title is the same as te?t except character ? will be migrated. For example, test will be migrated. | ||
| Title | Does not match | |||
| (This filter rule is case sensitive.) | te*t | All the site collections except those whose titles begin with te and end with t will be migrated. For example, Fly will be migrated. | ||
| Title | Does not match | |||
| (This filter rule is case sensitive.) | te?t | All the site collections except those whose titles are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | ||
| Created time | On or before | 11/01/2021 12:15 | The site collection that is created before 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On or after | 11/01/2021 12:15 | The site collection that is created at or after 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On | 11/01/2021 | The site collection that is created on 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Within | 5 Days | The site collection that is created in the last 5 days will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Earlier than | 5 Days | The site collection that is created more than 5 days ago will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or before | 11/01/2021 12:15 | The site collection that is last modified before 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or after | 11/01/2021 12:15 | The site collection that is last modified at or after 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On | 11/01/2021 | The site collection that is last modified on 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Within | 5 Days | The site collection that is last modified in the last 5 days will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Earlier than | 5 Days | The site collection that is last modified more than 5 days ago will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Primary administrator | Contains | admin | The site collection whose Primary Administrator's NoPrefixLoginName/LoginName/Title contains admin will be migrated. For example, the site collection whose Primary Administrator is admin@contoso.onmicrosoft.com will be migrated. | |
| Primary administrator | Equals | admin@contoso.onmicrosoft.com | The site collection whose Primary Administrator's NoPrefixLoginName/LoginName/Title is admin@contoso.onmicrosoft.com will be migrated. | |
| Template name | Contains | Team | The site collection whose template name contains Team will be migrated. For example, Team Site will be migrated. | |
| Template name | Does not contain | Team | The site collection whose template name does not contain Team will be migrated. For example, Blank Site will be migrated. | |
| Template name | Equals | Blank Site | The site collection whose template name is Blank Site will be migrated. | |
| Template name | Does not equal | Blank Site | The site collection whose template name is not Blank Site will be migrated. | |
| Template name | Matches | |||
| (This filter rule is case sensitive.) | B*Workspace | The site collection whose template name begins with B and ends with Workspace will be migrated. For example, Basic Meeting Workspace and Blank Meeting Workspace will be migrated. | ||
| Template name | Matches | |||
| (This filter rule is case sensitive.) | Bl?g | The site collection whose template name is the same as Bl?g except character ? will be migrated. For example, Blog will be migrated. | ||
| Template name | Does not match(This filter rule is case sensitive.) | B*Workspace | All the site collections except those whose templates’ names begin with B and ends with Workspace will be migrated. For example, Team Site be migrated. | |
| Template name | Does not match(This filter rule is case sensitive.) | Bl?g | All the site collections except those whose templates’ names are the same as Bl?g except character ? will be migrated. For example, Team Site will be migrated. | |
| Template ID | Equals | STS# | The site collection whose template ID is STS# will be migrated. For example, STS#0 (Team Site) will be migrated. | |
| Template ID | Does not equal | STS#0 | The site collection whose template ID is not STS#0 will be migrated. |
Only available for SharePoint Online Migration.
| Rule | Condition | Value | Result | Comment |
|---|---|---|---|---|
| URL | Contains | test | The site whose URL contains test will be migrated. For example, http://contoso.onmicrosoft.com/sites/sc/test and http://webapp:20000/sites/testA will be migrated. | |
| URL | Does not contain | test | The site whose URL does not contain test will be migrated. For example, http://contoso.onmicrosoft.com/sites/sc/AP will be migrated. | |
| URL | Equals | http://contoso.onmicrosoft.com/sites/sc/test | The site whose URL is http://contoso.onmicrosoft.com/sites/sc/test will be migrated. | |
| URL | Does not equal | http://contoso.onmicrosoft.com/sites/sc/test | The site whose URL is not http://contoso.onmicrosoft.com/sites/sc/test will be migrated. | |
| URL | Matches | |||
| (This filter rule is case sensitive.) | http://tes*siteA | The site whose URL begins with http://tes and ends with siteA will be migrated. For example, http://tescontoso.onmicrosoft.com/sc/siteA will be migrated. | ||
| URL | Matches | |||
| (This filter rule is case sensitive.) | http://contoso.onmicrosoft.com/sites/sc/si?eA | The site whose URL is the same as http://contoso.onmicrosoft.com/sites/sc/si?eA except character ? will be migrated. For example, http:// contoso.onmicrosoft.com/sites/sc/siteA and http://test:20000/sites/sc/siBeA will both be migrated. | ||
| URL | Does not match | |||
| (This filter rule is case sensitive.) | http://tes*siteA | All the sites except those whose URLs begin with http://tes and end with siteA will be migrated. For example, http://contoso1.onmicrosoft.com/sites/sc/test will be migrated. | ||
| URL | Does not match | |||
| (This filter rule is case sensitive.) | http://contoso.onmicrosoft.com/sites/sc/si?eA | All the sites except those whose URLs are the same as http://contoso.onmicrosoft.com/sites/sc/si?eA except character ? will be migrated. For example, http:// contoso1.onmicrosoft.com/sites/sc/test will be migrated. | ||
| Title | Contains | test | The site whose title contains test will be migrated. | |
| Title | Does not contain | test | The site whose title does not contain test will be migrated. | |
| Title | Equals | test | The site whose title is test will be migrated. | |
| Title | Does not equal | test | The site whose title is not test will be migrated. | |
| Title | Matches | |||
| (This filter rule is case sensitive.) | te*t | The site whose title begins with te and ends with t will be migrated. For example, teABct will be migrated. | ||
| Title | Matches | |||
| (This filter rule is case sensitive.) | te?t | The site whose title is the same as te?t except character ? will be migrated. For example, test will be migrated. | ||
| Title | Does not match | |||
| (This filter rule is case sensitive.) | te*t | All the sites except those whose titles begin with te and end with t will be migrated. For example, Fly will be migrated. | ||
| Title | Does not match | |||
| (This filter rule is case sensitive.) | te?t | All the sites except those whose titles are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | ||
| Created time | On or before | 11/01/2021 12:15 | The site that is created before 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On or after | 11/01/2021 12:15 | The site that is created at or after 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On | 11/01/2021 | The site that was created on 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Within | 5 Days | The site that is created in the last 5 days will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Earlier than | 5 Days | The site that was created more than 5 days ago will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or before | 11/01/2021 12:15 | The site that is last modified before 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or after | 11/01/2021 12:15 | The site that is last modified at or after 12:15 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On | 11/01/2021 | The site that was last modified on 11/01/2021 will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Within | 5 Days | The site that is last modified in the last 5 days will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Earlier than | 5 Days | The site that was last modified more than 5 days ago will be migrated. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Template name | Contains | Team | The site whose template name contains Team will be migrated. For example, Team Site will be migrated. | |
| Template name | Does not contain | Team | The site whose template name does not contain Team will be migrated. For example, Blank Site will be migrated. | |
| Template name | Equals | Blank Site | The site whose template name is Blank Site will be migrated. | |
| Template name | Does not equal | Blank Site | The site whose template name is not Blank Site will be migrated. | |
| Template name | Matches | |||
| (This filter rule is case sensitive.) | B*Workspace | The site whose template name begins with B and ends with Workspace will be migrated. For example, Basic Meeting Workspace and Blank Meeting Workspace will be migrated. | ||
| Template name | Matches | |||
| (This filter rule is case sensitive.) | Bl?g | The site whose template name is the same as Bl?g except character ? will be migrated. For example, Blog will be migrated. | ||
| Template name | Does not match | |||
| (This filter rule is case sensitive.) | B*Workspace | All the sites except those whose templates’ names begin with B and ends with Workspace will be migrated. For example, Team Site be migrated. | ||
| Template name | Does not match | |||
| (This filter rule is case sensitive.) | Bl?g | All the sites except those whose templates’ names are the same as Bl?g except character ? will be migrated. For example, Team Site will be migrated. | ||
| Template ID | Equals | STS# | The site whose template ID is STS# will be migrated. For example, STS#0 (Team Site) will be migrated. | |
| Template ID | Does not equal | STS#0 | The site whose template ID is not STS#0 will be migrated. |
| Rule | Condition | Value | Result | Comment |
|---|---|---|---|---|
| Name | Contains | test | The list/library whose name contains test will be migrated. | |
| Name | Does not contain | test | The list/library whose name does not contain test will be migrated. | |
| Name | Equals | test | The list/library whose name is test will be migrated. | |
| Name | Does not equal | test | The list/library whose name is not test will be migrated. | |
| Name | Matches | |||
| (This filter rule is case sensitive.) | te*t | The list/library whose name begins with te and ends with t will be migrated. For example, teABct will be migrated. | ||
| Name | Matches | |||
| (This filter rule is case sensitive.) | te?t | The list/library whose name is the same as te?t except character ? will be migrated. For example, test will be migrated. | ||
| Name | Does not match | |||
| (This filter rule is case sensitive.) | te*t | All the lists/libraries except those whose names begin with te and end with t will be migrated. For example, Fly will be migrated. | ||
| Name | Does not match | |||
| (This filter rule is case sensitive.) | te?t | All the lists/libraries except those whose names are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | ||
| Created time | On or before | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Created time | On or after | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Within | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Earlier than | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or before | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or after | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Within | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Earlier than | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Template name | Contains | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Template name | Does not contain | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Template name | Equals | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Template name | Does not equal | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Template name | Matches | |||
| (This filter rule is case sensitive.) | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | ||
| Template name | Does not match | |||
| (This filter rule is case sensitive.) | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | ||
| Template ID | Equals | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Template ID | Does not equal | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | |
| Column: Display name | Contains | Text | The list/library that contains the column whose display name is Text will be migrated. | |
| Column: Display name | Does not contain | Text | The list/library that does not contain the column whose display name is Text will be migrated. | |
| Number of list items | >= | 5 | The list/library that contains 5 or more than 5 items will be migrated. | |
| Number of list items | <= | 5 | The list/library that contains 5 or less than 5 items will be migrated. | |
| Number of list items | = | 5 | The list/library that contains 5 items will be migrated. | |
| Content type: Name | Contains | Test | The list/library that contains the content type whose name contains Test will be migrated. | |
| Content type: Name | Does not contain | Test | The list/library that contains the content type whose name does not contain Test will be migrated. | |
| Content type: ID | Equals | 0x007874566ED32546ABE3B1BC74A7D5F8 | The list/library that contains the content type whose ID is 0x007874566ED32546ABE3B1BC74A7D5F8 will be migrated. | |
| Content type: ID | Does not equal | 0x007874566ED32546ABE3B1BC74A7D5F8 | The list/library that contains the content type whose ID is not 0x007874566ED32546ABE3B1BC74A7D5F8 will be migrated. |
| Rule | Condition | Value | Result | Comment |
|---|---|---|---|---|
| Name | Contains | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | |
| Name | Does not contain | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | |
| Name | Equals | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | |
| Name | Does not equal | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | |
| Name | Matches(This filter rule is case sensitive.) | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | |
| Name | Does not match(This filter rule is case sensitive.) | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | |
| Created time | On or before | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On or after | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Within | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Earlier than | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or before | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or after | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Within | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Earlier than | Refer to the same filter rule in List Level. | Refer to the same filter rule in List Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created by | Contains | test | The folder whose creator's NoPrefixLoginName/LoginName/Title contains test will be migrated. For example, the folders that are created by test@contoso.onmicrosoft.com will be migrated. | |
| Created by | Equals | test@contoso.onmicrosoft.com | The folder whose creator's NoPrefixLoginName/LoginName/Title is test@contoso.onmicrosoft.com will be migrated. | |
| Content type: Name | Contains | Task | The folder whose content type name contains Task will be migrated. | |
| Content type: Name | Does not contain | Task | The folder whose content type name does not contain Task will be migrated. | |
| Content type: ID | Equals | D5F8 | The folder whose content type ID is D5F8 will be migrated. | |
| Content type: ID | Does not equal | D5F8 | The folder whose content type ID is not D5F8 will be migrated. | |
| Column: Text | Contains | test | The folder whose Text column value contains test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not contain | test | The folder whose Text column value does not contain test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Equals | test | The folder whose Text column value is test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not equal | test | The folder whose Text column value is not test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Matches(This filter rule is case sensitive.) | te*t | The folder whose Text column value begins with te and ends with t will be migrated. For example, teABct will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Matches(This filter rule is case sensitive.) | te?t | The folder whose Text column value is the same as te?t except character ? will be migrated. For example, test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not match(This filter rule is case sensitive.) | te*t | All the folders except those whose Text column values begin with te and end with t will be migrated. For example, Fly will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not match(This filter rule is case sensitive.) | te?t | All the folders except those whose Text column values are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Number | >= | 5 | The folder whose Number column value is not smaller than 5 will be migrated. For example, 8 will be migrated. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Number | <= | 5 | The folder whose Number column value is not bigger than 5 will be migrated. For example, 2 will be migrated. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Number | = | 5 | The folder whose Number column value is 5 will be migrated. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Yes/No | Equals | Yes | The folder whose Choice column value is Yes will be migrated. | *Note: Enter a display name of the Choice column you are about to filter next to Column: Yes/No. |
| Column: Date and Time | On or before | 11/01/2021 12:15 | The folder whose Date and Time column value is before 12:15 11/01/2021 will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | On or after | 11/01/2021 12:15 | The folder whose Date and Time column value is at or after 12:15 11/01/2021 will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | On | 11/01/2021 | The folder whose Date and Time column value is on 11/01/2021 will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | Within | 5 Days | The folder whose Date and Time column value is dated in the last 5 days will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | Earlier Than | 5 Days | The folder whose Date and Time column value is dated more than 5 days ago will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Rule | Condition | Value | Result | Comment |
|---|---|---|---|---|
| Title | Contains | test | The item whose title contains test will be migrated. | |
| Title | Does not contain | test | The item whose title does not contain test will be migrated. | |
| Title | Equals | test | The item whose title is test will be migrated. | |
| Title | Does not equal | test | The item whose title is not test will be migrated. | |
| Title | Matches | |||
| (This filter rule is case sensitive.) | te*t | The item whose title begins with te and ends with t will be migrated. For example, teABct will be migrated. | ||
| Title | Matches | |||
| (This filter rule is case sensitive.) | te?t | The item whose title is the same as te?t except character ? will be migrated. For example, test will be migrated. | ||
| Title | Does not match | |||
| (This filter rule is case sensitive.) | te*t | All the items except those whose titles begin with te and end with t will be migrated. For example, Fly will be migrated. | ||
| Title | Does not match | |||
| (This filter rule is case sensitive.) | te?t | All the items except those whose titles are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | ||
| Created time | On or before | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On or after | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Within | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Earlier than | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or before | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or After | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Within | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Earlier than | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created by | Contains | Refer to the same filter rule in Folder Level. | Refer to the same filter rule in Folder Level. | |
| Created by | Equals | Refer to the same filter rule in Folder Level. | Refer to the same filter rule in Folder Level. | |
| Modified by | Contains | test | The items whose modifier's NoPrefixLoginName/LoginName/Title contains test will be migrated. For example, the items whose modifiers are test@contoso.onmicrosoft.com will be migrated. | |
| Modified by | Equals | test@contoso.onmicrosoft.com | The item whose modifier's NoPrefixLoginName/LoginName/Title is test@contoso.onmicrosoft.com will be migrated. | |
| Content type: Name | Contains | Task | The item whose content type name contains Task will be migrated. | |
| Content type: Name | Does not contain | Task | The item whose content type name does not contain Task will be migrated. | |
| Content type: ID | Equals | D5F8 | The item whose content type ID is D5F8 will be migrated. | |
| Content type: ID | Does not equal | D5F8 | The item whose content type ID is not D5F8 will be migrated. | |
| Version | Current version and latest [] versions | 3 | The item’s last 4 versions will be migrated. For example, an item has the following versions: 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, then, version 3.0, 4.0, 5.0 and the current version 6.0 will be migrated. | |
| Version | Current version and latest [] major versions | 3 | The item’s last 3 major versions and the current version will be migrated. For example, if an item has the following versions: 1.0, 2.0, 2.1, 2.2, 3.0, 3.1, and then the major version 1.0, 2.0, 3.0, and the current version 3.1 will be migrated. | |
| Version | Current version and approved versions | N/A | All approved versions and the current version will be migrated. | |
| Version | Current version and major versions | N/A | All major versions and the current version will be migrated. | |
| Version | No history version | N/A | No history versions will be migrated. | |
| Column: Text | Contains | test | The item whose Text column value contains test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not contain | test | The item whose Text column value does not contain test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Equals | test | The item whose Text column value is test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not equal | test | The item whose Text column value is not test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Matches | |||
| (This filter rule is case sensitive.) | te*t | The item whose Text column value begins with te and ends with t will be migrated. For example, teABct will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. | |
| Column: Text | Matches | |||
| (This filter rule is case sensitive.) | te?t | The item whose Text column value is the same as te?t except character ? will be migrated. For example, test will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. | |
| Column: Text | Does not match | |||
| (This filter rule is case sensitive.) | te*t | All the items except those whose Text column values begin with te and end with t will be migrated. For example, Fly will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. | |
| Column: Text | Does not match | |||
| (This filter rule is case sensitive.) | te?t | All the items except those whose Text column values are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. | |
| Column: Number | >= | 5 | The item whose Number column value is not smaller than 5 will be migrated. For example, 8 will be migrated. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Number | <= | 5 | The item whose Number column value is not bigger than 5 will be migrated. For example, 2 will be migrated. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Number | = | 5 | The item whose Number column value is 5 will be migrated. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Yes/No | Equals | Yes | The item whose Choice column value is Yes will be migrated. | *Note: Enter a display name of the Choice column you are about to filter next to Column: Yes/No. |
| Column: Date and Time | On or before | 11/01/2021 12:15 | The item whose Date and Time column value is earlier than 12:15 11/01/2021 will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | On or after | 11/01/2021 12:15 | The item whose Date and Time column value is not earlier than 12:15 11/01/2021 will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | On | 11/01/2021 | The item whose Date and Time column value is on 11/01/2021 will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | Within | 5 Days | The item whose Date and Time column value is dated in the last 5 days will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | Earlier than | 5 Days | The item whose Date and Time column value is dated more than 5 days ago will be migrated. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Rule | Condition | Value | Result | Comment |
|---|---|---|---|---|
| Name | Contains | test.docx | The document whose name contains test.docx will be migrated. For example, abctest.docx will be migrated. | |
| Name | Does not contain | test.docx | The document whose name does not contain test.docx will be migrated. For example, Fly.docx will be migrated. | |
| Name | Equals | test.docx | The document whose name is test.docx will be migrated. | |
| Name | Does not equal | test.docx | The document whose name is not test.docx will be migrated. | |
| Name | Matches | |||
| (This filter rule is case sensitive.) | te*t.docx | The document whose name begins with te and ends with t.docx will be migrated. For example, test.docx will be migrated. | ||
| Name | Matches | |||
| (This filter rule is case sensitive.) | te?t.docx | The document whose name is the same as te?t except character ? will be migrated. For example, teAt.docx will be migrated. | ||
| Name | Does not match | |||
| (This filter rule is case sensitive.) | te*t.docx | All the documents except those whose names begin with te and end with t.docx will be migrated. For example, Fly.txt will be migrated. | ||
| Name | Does not match | |||
| (This filter rule is case sensitive.) | te?t.docx | All the documents except those whose names are the same as te?t.docx except character ? will be migrated. For example, Fly.txt will be migrated. | ||
| File extension | Equals | .docx | The document whose extension equals .docx will be migrated. For example, Sample.docx will be migrated. | |
| File extension | Does not equal | .docx | The document whose extension does not equal .docx will be migrated. For example, Sample.txt will be migrated. | |
| Size | >= | 1MB | The document whose size is not smaller than 1MB will be migrated. For example, a 2MB document will be migrated. | |
| Size | <= | 1MB | The document whose size is not bigger than 5 will be migrated. For example, a 500KB document will be migrated. | |
| Created time | On or before | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On or after | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | On | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Within | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created time | Earlier than | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or before | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On or after | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | On | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Within | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Modified time | Earlier than | Refer to the same filter rule in Site Collection Level. | Refer to the same filter rule in Site Collection Level. | Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Created by | Contains | Refer to the same filter rule in Folder Level. | Refer to the same filter rule in Folder Level. | |
| Created by | Equals | Refer to the same filter rule in Folder Level. | Refer to the same filter rule in Folder Level. | |
| Modified by | Contains | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | |
| Modified by | Equals | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | |
| Sensitivity label | Contains | labelA | The document whose sensitivity name contains labelA will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Does not contain | labelA | The document whose sensitivity name does not contain labelA will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Equals | labelA | The document whose sensitivity name is labelA will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Does not equal | labelA | The document whose sensitivity name is not labelA will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Matches(This filter rule is case sensitive.) | la*l | The document whose sensitivity name begins with la and ends with l will be migrated. For example, laABl will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Matches(This filter rule is case sensitive.) | la?l | The document whose sensitivity name is the same as la?l except character ? will be migrated. For example, labl will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Does not match(This filter rule is case sensitive.) | la*l | All documents except those whose sensitivity names begin with la and end with l will be migrated. For example, Fly will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Sensitivity label | Does not match(This filter rule is case sensitive.) | la?l | All documents except those whose sensitivity names are the same as te?t except character ? will be migrated. For example, Fly will be migrated. | *Note: If the sensitivity label is not displayed in the library where the document is stored, the configured sensitivity label filter will not work during the migration. |
| Content type: Name | Contains | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | |
| Content type: Name | Does not contain | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | |
| Content type: ID | Equals | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | |
| Content type: ID | Does not equal | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | |
| Version | Current version and latest [] versions | 3 | The document’s last 4 versions will be migrated. For example, if a document has the following versions: 1.0, 1.1, 2.0, 2.1, 2.2, then version 1.1, 2.0, 2.1, and the current version 2.2 will be migrated. | |
| Version | Current version and latest [] major versions | 3 | The document’s last 3 major versions and the current version will be migrated. For example, if a document has the following versions: 1.0, 2.0, 2.1, 2.2, 3.0, 3.1, and then the major version 1.0, 2.0, 3.0, and the current version 3.1 will be migrated. | |
| Version | Current version and approved versions | N/A | All approved versions and the current version will be migrated. | |
| Version | Current version and major versions | N/A | All major versions and the current version will be migrated. | |
| Version | No history version | N/A | No history versions will be migrated. | |
| Column: Text | Contains | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not contain | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Equals | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Does not equal | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. |
| Column: Text | Matches | |||
| (This filter rule is case sensitive.) | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. | |
| Column: Text | Does not match | |||
| (This filter rule is case sensitive.) | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Text column you are about to filter next to Column: Text. | |
| Column: Number | >= | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Number | <= | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Number | = | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Number column you are about to filter next to Column: Number. |
| Column: Yes/No | Equals | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Choice column you are about to filter next to Column: Yes/No. |
| Column: Date and Time | On or before | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | On or after | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | On | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | Within | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |
| Column: Date and Time | Earlier than | Refer to the same filter rule in Item Level. | Refer to the same filter rule in Item Level. | *Note: Enter a display name of the Date and Time column you are about to filter next to Column: Date and Time.*Note: Fly will compare the data time based on UTC time.Make sure the time zones of your browser and site collections are consistent.If the time zones are different, you need to convert the time of your browser and site collections to the UTC time. |