Filter: FileFilter

Filter type for File.

All fields in this type are and-combined; see the or field for or-combination.

File

Input Fields

Name	Type	Description
AND	FileFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	FileFilter	A field that checks if any of the filters in the list apply. If the list is empty, this filter applies to no objects. Note that only the items in the list or-combined; this complete `OR` field is and-combined with outer fields in the parent filter type.
children_empty	Boolean	Checks if `children` is an empty list (true) or a non-empty list or null (false).
children_every	FileFilter	Makes sure all items in `children` match a certain filter.
children_none	FileFilter	Makes sure none of the items in `children` match a certain filter. Note that you can specify the empty object for this filter to make sure `children` has no items.
children_some	FileFilter	Makes sure at least one of the items in "children" matches a certain filter. Note that you can specify the empty object for this filter to make sure `children` has at least one item.
contentsLink	String	Checks if `contentsLink` equals a specified string, case-sensitively. If an index exists on `contentsLink`, it can be used. See also `like` for a case-insensitive filter. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_contains	String	Checks if `contentsLink` contains a specified string, case-sensitively. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_ends_with	String	Checks if `contentsLink` ends with a specified string, case-sensitively. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_gt	String	Checks if `contentsLink` is greater than a specified value. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_gte	String	Checks if `contentsLink` is greater or equal a specified value. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_in	String	Checks if `contentsLink` is equal to one of the specified values. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_like	String	Matches `contentsLink` against a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); If an index exists on `contentsLink`, it can be used for the literal prefix (the part until the first placeholder). Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_lt	String	Checks if `contentsLink` is less than a specified value. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_lte	String	Checks if `contentsLink` is less or equal a specified value. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_not	String	Checks if `contentsLink` does not equal a specified string, case-sensitively. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_not_contains	String	Checks if `contentsLink` does not contain a specified string, case-sensitively. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_not_ends_with	String	Checks if `contentsLink` does not end with a specified string, case-sensitively. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_not_in	String	Checks if `contentsLink` is not equal to one of the specified values. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_not_like	String	Checks if `contentsLink` does not match a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_not_starts_with	String	Checks if `contentsLink` does not start with a specified string, case-sensitively. Never uses an index. Consider using `not_like` (with the `%` placeholder) for a case-insensitive filter that can use an index. Link to a location where the full file contents can be downloaded/viewed (if available)
contentsLink_starts_with	String	Checks if `contentsLink` starts with a specified string, case-sensitively. Never uses an index. Consider using `like` (with the `%` placeholder) for a case-insensitive filter that can use an index. Link to a location where the full file contents can be downloaded/viewed (if available)
createdAt	DateTime	Checks if `createdAt` equals a specified value. If an index exists on `createdAt`, it can be used. The instant this object has been created
createdAt_gt	DateTime	Checks if `createdAt` is greater than a specified value. The instant this object has been created
createdAt_gte	DateTime	Checks if `createdAt` is greater or equal a specified value. The instant this object has been created
createdAt_in	DateTime	Checks if `createdAt` is equal to one of the specified values. The instant this object has been created
createdAt_lt	DateTime	Checks if `createdAt` is less than a specified value. The instant this object has been created
createdAt_lte	DateTime	Checks if `createdAt` is less or equal a specified value. The instant this object has been created
createdAt_not	DateTime	Checks if `createdAt` does not equal a specified value The instant this object has been created
createdAt_not_in	DateTime	Checks if `createdAt` is not equal to one of the specified values. The instant this object has been created
ctx	RelationEntityCtxFilter	Allows to filter on the fields of `ctx`. Note that `ctx` is an entity extension and thus can never be `null`, so specifying `null` to this filter field has no effect.
hashes_empty	Boolean	Checks if `hashes` is an empty list (true) or a non-empty list or null (false).
hashes_every	HashFilter	Makes sure all items in `hashes` match a certain filter.
hashes_none	HashFilter	Makes sure none of the items in `hashes` match a certain filter. Note that you can specify the empty object for this filter to make sure `hashes` has no items.
hashes_some	HashFilter	Makes sure at least one of the items in "hashes" matches a certain filter. Note that you can specify the empty object for this filter to make sure `hashes` has at least one item.
id	ID	Checks if `id` equals a specified value. If an index exists on `id`, it can be used. An auto-generated string that identifies this root entity uniquely among others of the same type
id_gt	ID	Checks if `id` is greater than a specified value. An auto-generated string that identifies this root entity uniquely among others of the same type
id_gte	ID	Checks if `id` is greater or equal a specified value. An auto-generated string that identifies this root entity uniquely among others of the same type
id_in	ID	Checks if `id` is equal to one of the specified values. An auto-generated string that identifies this root entity uniquely among others of the same type
id_lt	ID	Checks if `id` is less than a specified value. An auto-generated string that identifies this root entity uniquely among others of the same type
id_lte	ID	Checks if `id` is less or equal a specified value. An auto-generated string that identifies this root entity uniquely among others of the same type
id_not	ID	Checks if `id` does not equal a specified value An auto-generated string that identifies this root entity uniquely among others of the same type
id_not_in	ID	Checks if `id` is not equal to one of the specified values. An auto-generated string that identifies this root entity uniquely among others of the same type
modifiedDate	DateTime	Checks if `modifiedDate` equals a specified value. If an index exists on `modifiedDate`, it can be used. The date the file was last modified in the original file system
modifiedDate_gt	DateTime	Checks if `modifiedDate` is greater than a specified value. The date the file was last modified in the original file system
modifiedDate_gte	DateTime	Checks if `modifiedDate` is greater or equal a specified value. The date the file was last modified in the original file system
modifiedDate_in	DateTime	Checks if `modifiedDate` is equal to one of the specified values. The date the file was last modified in the original file system
modifiedDate_lt	DateTime	Checks if `modifiedDate` is less than a specified value. The date the file was last modified in the original file system
modifiedDate_lte	DateTime	Checks if `modifiedDate` is less or equal a specified value. The date the file was last modified in the original file system
modifiedDate_not	DateTime	Checks if `modifiedDate` does not equal a specified value The date the file was last modified in the original file system
modifiedDate_not_in	DateTime	Checks if `modifiedDate` is not equal to one of the specified values. The date the file was last modified in the original file system
name	String	Checks if `name` equals a specified string, case-sensitively. If an index exists on `name`, it can be used. See also `like` for a case-insensitive filter. The file name of the file without the full path
name_contains	String	Checks if `name` contains a specified string, case-sensitively. The file name of the file without the full path
name_ends_with	String	Checks if `name` ends with a specified string, case-sensitively. The file name of the file without the full path
name_gt	String	Checks if `name` is greater than a specified value. The file name of the file without the full path
name_gte	String	Checks if `name` is greater or equal a specified value. The file name of the file without the full path
name_in	String	Checks if `name` is equal to one of the specified values. The file name of the file without the full path
name_like	String	Matches `name` against a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); If an index exists on `name`, it can be used for the literal prefix (the part until the first placeholder). The file name of the file without the full path
name_lt	String	Checks if `name` is less than a specified value. The file name of the file without the full path
name_lte	String	Checks if `name` is less or equal a specified value. The file name of the file without the full path
name_not	String	Checks if `name` does not equal a specified string, case-sensitively. The file name of the file without the full path
name_not_contains	String	Checks if `name` does not contain a specified string, case-sensitively. The file name of the file without the full path
name_not_ends_with	String	Checks if `name` does not end with a specified string, case-sensitively. The file name of the file without the full path
name_not_in	String	Checks if `name` is not equal to one of the specified values. The file name of the file without the full path
name_not_like	String	Checks if `name` does not match a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); The file name of the file without the full path
name_not_starts_with	String	Checks if `name` does not start with a specified string, case-sensitively. Never uses an index. Consider using `not_like` (with the `%` placeholder) for a case-insensitive filter that can use an index. The file name of the file without the full path
name_starts_with	String	Checks if `name` starts with a specified string, case-sensitively. Never uses an index. Consider using `like` (with the `%` placeholder) for a case-insensitive filter that can use an index. The file name of the file without the full path
path	String	Checks if `path` equals a specified string, case-sensitively. If an index exists on `path`, it can be used. See also `like` for a case-insensitive filter. The full path to this file within the original filesystem
path_contains	String	Checks if `path` contains a specified string, case-sensitively. The full path to this file within the original filesystem
path_ends_with	String	Checks if `path` ends with a specified string, case-sensitively. The full path to this file within the original filesystem
path_gt	String	Checks if `path` is greater than a specified value. The full path to this file within the original filesystem
path_gte	String	Checks if `path` is greater or equal a specified value. The full path to this file within the original filesystem
path_in	String	Checks if `path` is equal to one of the specified values. The full path to this file within the original filesystem
path_like	String	Matches `path` against a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); If an index exists on `path`, it can be used for the literal prefix (the part until the first placeholder). The full path to this file within the original filesystem
path_lt	String	Checks if `path` is less than a specified value. The full path to this file within the original filesystem
path_lte	String	Checks if `path` is less or equal a specified value. The full path to this file within the original filesystem
path_not	String	Checks if `path` does not equal a specified string, case-sensitively. The full path to this file within the original filesystem
path_not_contains	String	Checks if `path` does not contain a specified string, case-sensitively. The full path to this file within the original filesystem
path_not_ends_with	String	Checks if `path` does not end with a specified string, case-sensitively. The full path to this file within the original filesystem
path_not_in	String	Checks if `path` is not equal to one of the specified values. The full path to this file within the original filesystem
path_not_like	String	Checks if `path` does not match a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); The full path to this file within the original filesystem
path_not_starts_with	String	Checks if `path` does not start with a specified string, case-sensitively. Never uses an index. Consider using `not_like` (with the `%` placeholder) for a case-insensitive filter that can use an index. The full path to this file within the original filesystem
path_starts_with	String	Checks if `path` starts with a specified string, case-sensitively. Never uses an index. Consider using `like` (with the `%` placeholder) for a case-insensitive filter that can use an index. The full path to this file within the original filesystem
permissions	String	Checks if `permissions` equals a specified string, case-sensitively. If an index exists on `permissions`, it can be used. See also `like` for a case-insensitive filter. The permissions associated with the file in the original file system.
permissions_contains	String	Checks if `permissions` contains a specified string, case-sensitively. The permissions associated with the file in the original file system.
permissions_ends_with	String	Checks if `permissions` ends with a specified string, case-sensitively. The permissions associated with the file in the original file system.
permissions_gt	String	Checks if `permissions` is greater than a specified value. The permissions associated with the file in the original file system.
permissions_gte	String	Checks if `permissions` is greater or equal a specified value. The permissions associated with the file in the original file system.
permissions_in	String	Checks if `permissions` is equal to one of the specified values. The permissions associated with the file in the original file system.
permissions_like	String	Matches `permissions` against a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); If an index exists on `permissions`, it can be used for the literal prefix (the part until the first placeholder). The permissions associated with the file in the original file system.
permissions_lt	String	Checks if `permissions` is less than a specified value. The permissions associated with the file in the original file system.
permissions_lte	String	Checks if `permissions` is less or equal a specified value. The permissions associated with the file in the original file system.
permissions_not	String	Checks if `permissions` does not equal a specified string, case-sensitively. The permissions associated with the file in the original file system.
permissions_not_contains	String	Checks if `permissions` does not contain a specified string, case-sensitively. The permissions associated with the file in the original file system.
permissions_not_ends_with	String	Checks if `permissions` does not end with a specified string, case-sensitively. The permissions associated with the file in the original file system.
permissions_not_in	String	Checks if `permissions` is not equal to one of the specified values. The permissions associated with the file in the original file system.
permissions_not_like	String	Checks if `permissions` does not match a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); The permissions associated with the file in the original file system.
permissions_not_starts_with	String	Checks if `permissions` does not start with a specified string, case-sensitively. Never uses an index. Consider using `not_like` (with the `%` placeholder) for a case-insensitive filter that can use an index. The permissions associated with the file in the original file system.
permissions_starts_with	String	Checks if `permissions` starts with a specified string, case-sensitively. Never uses an index. Consider using `like` (with the `%` placeholder) for a case-insensitive filter that can use an index. The permissions associated with the file in the original file system.
size	Int	Checks if `size` equals a specified value. If an index exists on `size`, it can be used. File size in bytes
size_gt	Int	Checks if `size` is greater than a specified value. File size in bytes
size_gte	Int	Checks if `size` is greater or equal a specified value. File size in bytes
size_in	Int	Checks if `size` is equal to one of the specified values. File size in bytes
size_lt	Int	Checks if `size` is less than a specified value. File size in bytes
size_lte	Int	Checks if `size` is less or equal a specified value. File size in bytes
size_not	Int	Checks if `size` does not equal a specified value File size in bytes
size_not_in	Int	Checks if `size` is not equal to one of the specified values. File size in bytes
type	String	Checks if `type` equals a specified string, case-sensitively. If an index exists on `type`, it can be used. See also `like` for a case-insensitive filter. MIME type of this file
type_contains	String	Checks if `type` contains a specified string, case-sensitively. MIME type of this file
type_ends_with	String	Checks if `type` ends with a specified string, case-sensitively. MIME type of this file
type_gt	String	Checks if `type` is greater than a specified value. MIME type of this file
type_gte	String	Checks if `type` is greater or equal a specified value. MIME type of this file
type_in	String	Checks if `type` is equal to one of the specified values. MIME type of this file
type_like	String	Matches `type` against a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); If an index exists on `type`, it can be used for the literal prefix (the part until the first placeholder). MIME type of this file
type_lt	String	Checks if `type` is less than a specified value. MIME type of this file
type_lte	String	Checks if `type` is less or equal a specified value. MIME type of this file
type_not	String	Checks if `type` does not equal a specified string, case-sensitively. MIME type of this file
type_not_contains	String	Checks if `type` does not contain a specified string, case-sensitively. MIME type of this file
type_not_ends_with	String	Checks if `type` does not end with a specified string, case-sensitively. MIME type of this file
type_not_in	String	Checks if `type` is not equal to one of the specified values. MIME type of this file
type_not_like	String	Checks if `type` does not match a pattern case-insensitively with the following placeholders: `%` matches any sequence of characters, including the empty string; `_` matches exactly one character; `\` can be used to escape the placeholders (use `\\` for a literal backslash); MIME type of this file
type_not_starts_with	String	Checks if `type` does not start with a specified string, case-sensitively. Never uses an index. Consider using `not_like` (with the `%` placeholder) for a case-insensitive filter that can use an index. MIME type of this file
type_starts_with	String	Checks if `type` starts with a specified string, case-sensitively. Never uses an index. Consider using `like` (with the `%` placeholder) for a case-insensitive filter that can use an index. MIME type of this file
updatedAt	DateTime	Checks if `updatedAt` equals a specified value. If an index exists on `updatedAt`, it can be used. The instant this object has been updated the last time (not including relation updates)
updatedAt_gt	DateTime	Checks if `updatedAt` is greater than a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_gte	DateTime	Checks if `updatedAt` is greater or equal a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_in	DateTime	Checks if `updatedAt` is equal to one of the specified values. The instant this object has been updated the last time (not including relation updates)
updatedAt_lt	DateTime	Checks if `updatedAt` is less than a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_lte	DateTime	Checks if `updatedAt` is less or equal a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_not	DateTime	Checks if `updatedAt` does not equal a specified value The instant this object has been updated the last time (not including relation updates)
updatedAt_not_in	DateTime	Checks if `updatedAt` is not equal to one of the specified values. The instant this object has been updated the last time (not including relation updates)

This page was generated: 2024-11-06

Filter: FileFilter

Related Types

Input Fields