Filter: PatchFilter

Filter type for Patch.

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

Patch

Input Fields

Name	Type	Description
AND	PatchFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	PatchFilter	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.
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.
description	String	Checks if `description` equals a specified string, case-sensitively. If an index exists on `description`, it can be used. See also `like` for a case-insensitive filter. The description of the issue.
description_contains	String	Checks if `description` contains a specified string, case-sensitively. The description of the issue.
description_ends_with	String	Checks if `description` ends with a specified string, case-sensitively. The description of the issue.
description_gt	String	Checks if `description` is greater than a specified value. The description of the issue.
description_gte	String	Checks if `description` is greater or equal a specified value. The description of the issue.
description_in	String	Checks if `description` is equal to one of the specified values. The description of the issue.
description_like	String	Matches `description` 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 `description`, it can be used for the literal prefix (the part until the first placeholder). The description of the issue.
description_lt	String	Checks if `description` is less than a specified value. The description of the issue.
description_lte	String	Checks if `description` is less or equal a specified value. The description of the issue.
description_not	String	Checks if `description` does not equal a specified string, case-sensitively. The description of the issue.
description_not_contains	String	Checks if `description` does not contain a specified string, case-sensitively. The description of the issue.
description_not_ends_with	String	Checks if `description` does not end with a specified string, case-sensitively. The description of the issue.
description_not_in	String	Checks if `description` is not equal to one of the specified values. The description of the issue.
description_not_like	String	Checks if `description` 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 description of the issue.
description_not_starts_with	String	Checks if `description` 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 description of the issue.
description_starts_with	String	Checks if `description` 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 description of the issue.
finding	FindingFilter	Checks if `finding` is not null, and allows to filter based on its fields.
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
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 name of the issue.
name_contains	String	Checks if `name` contains a specified string, case-sensitively. The name of the issue.
name_ends_with	String	Checks if `name` ends with a specified string, case-sensitively. The name of the issue.
name_gt	String	Checks if `name` is greater than a specified value. The name of the issue.
name_gte	String	Checks if `name` is greater or equal a specified value. The name of the issue.
name_in	String	Checks if `name` is equal to one of the specified values. The name of the issue.
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 name of the issue.
name_lt	String	Checks if `name` is less than a specified value. The name of the issue.
name_lte	String	Checks if `name` is less or equal a specified value. The name of the issue.
name_not	String	Checks if `name` does not equal a specified string, case-sensitively. The name of the issue.
name_not_contains	String	Checks if `name` does not contain a specified string, case-sensitively. The name of the issue.
name_not_ends_with	String	Checks if `name` does not end with a specified string, case-sensitively. The name of the issue.
name_not_in	String	Checks if `name` is not equal to one of the specified values. The name of the issue.
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 name of the issue.
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 name of the issue.
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 name of the issue.
reference_empty	Boolean	Checks if `reference` is an empty list (true) or a non-empty list or null (false).
reference_every	StringFilter	Makes sure all items in `reference` match a certain filter.
reference_none	StringFilter	Makes sure none of the items in `reference` match a certain filter. Note that you can specify the empty object for this filter to make sure `reference` has no items.
reference_some	StringFilter	Makes sure at least one of the items in "reference" matches a certain filter. Note that you can specify the empty object for this filter to make sure `reference` has at least one item.
resolutionType	PatchResolutionType	Checks if `resolutionType` equals a specified value. If an index exists on `resolutionType`, it can be used. The type of issue.
resolutionType_in	PatchResolutionType	Checks if `resolutionType` is equal to one of the specified values. The type of issue.
resolutionType_not	PatchResolutionType	Checks if `resolutionType` does not equal a specified value The type of issue.
resolutionType_not_in	PatchResolutionType	Checks if `resolutionType` is not equal to one of the specified values. The type of issue.
sourceId	String	Checks if `sourceId` equals a specified string, case-sensitively. If an index exists on `sourceId`, it can be used. See also `like` for a case-insensitive filter. The identifier of the issue assigned by the source of the issue
sourceId_contains	String	Checks if `sourceId` contains a specified string, case-sensitively. The identifier of the issue assigned by the source of the issue
sourceId_ends_with	String	Checks if `sourceId` ends with a specified string, case-sensitively. The identifier of the issue assigned by the source of the issue
sourceId_gt	String	Checks if `sourceId` is greater than a specified value. The identifier of the issue assigned by the source of the issue
sourceId_gte	String	Checks if `sourceId` is greater or equal a specified value. The identifier of the issue assigned by the source of the issue
sourceId_in	String	Checks if `sourceId` is equal to one of the specified values. The identifier of the issue assigned by the source of the issue
sourceId_like	String	Matches `sourceId` 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 `sourceId`, it can be used for the literal prefix (the part until the first placeholder). The identifier of the issue assigned by the source of the issue
sourceId_lt	String	Checks if `sourceId` is less than a specified value. The identifier of the issue assigned by the source of the issue
sourceId_lte	String	Checks if `sourceId` is less or equal a specified value. The identifier of the issue assigned by the source of the issue
sourceId_not	String	Checks if `sourceId` does not equal a specified string, case-sensitively. The identifier of the issue assigned by the source of the issue
sourceId_not_contains	String	Checks if `sourceId` does not contain a specified string, case-sensitively. The identifier of the issue assigned by the source of the issue
sourceId_not_ends_with	String	Checks if `sourceId` does not end with a specified string, case-sensitively. The identifier of the issue assigned by the source of the issue
sourceId_not_in	String	Checks if `sourceId` is not equal to one of the specified values. The identifier of the issue assigned by the source of the issue
sourceId_not_like	String	Checks if `sourceId` 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 identifier of the issue assigned by the source of the issue
sourceId_not_starts_with	String	Checks if `sourceId` 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 identifier of the issue assigned by the source of the issue
sourceId_starts_with	String	Checks if `sourceId` 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 identifier of the issue assigned by the source of the issue
sourceName	String	Checks if `sourceName` equals a specified string, case-sensitively. If an index exists on `sourceName`, it can be used. See also `like` for a case-insensitive filter. The name of the source.
sourceName_contains	String	Checks if `sourceName` contains a specified string, case-sensitively. The name of the source.
sourceName_ends_with	String	Checks if `sourceName` ends with a specified string, case-sensitively. The name of the source.
sourceName_gt	String	Checks if `sourceName` is greater than a specified value. The name of the source.
sourceName_gte	String	Checks if `sourceName` is greater or equal a specified value. The name of the source.
sourceName_in	String	Checks if `sourceName` is equal to one of the specified values. The name of the source.
sourceName_like	String	Matches `sourceName` 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 `sourceName`, it can be used for the literal prefix (the part until the first placeholder). The name of the source.
sourceName_lt	String	Checks if `sourceName` is less than a specified value. The name of the source.
sourceName_lte	String	Checks if `sourceName` is less or equal a specified value. The name of the source.
sourceName_not	String	Checks if `sourceName` does not equal a specified string, case-sensitively. The name of the source.
sourceName_not_contains	String	Checks if `sourceName` does not contain a specified string, case-sensitively. The name of the source.
sourceName_not_ends_with	String	Checks if `sourceName` does not end with a specified string, case-sensitively. The name of the source.
sourceName_not_in	String	Checks if `sourceName` is not equal to one of the specified values. The name of the source.
sourceName_not_like	String	Checks if `sourceName` 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 name of the source.
sourceName_not_starts_with	String	Checks if `sourceName` 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 name of the source.
sourceName_starts_with	String	Checks if `sourceName` 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 name of the source.
sourceUrl	String	Checks if `sourceUrl` equals a specified string, case-sensitively. If an index exists on `sourceUrl`, it can be used. See also `like` for a case-insensitive filter. The URL for the source documentation.
sourceUrl_contains	String	Checks if `sourceUrl` contains a specified string, case-sensitively. The URL for the source documentation.
sourceUrl_ends_with	String	Checks if `sourceUrl` ends with a specified string, case-sensitively. The URL for the source documentation.
sourceUrl_gt	String	Checks if `sourceUrl` is greater than a specified value. The URL for the source documentation.
sourceUrl_gte	String	Checks if `sourceUrl` is greater or equal a specified value. The URL for the source documentation.
sourceUrl_in	String	Checks if `sourceUrl` is equal to one of the specified values. The URL for the source documentation.
sourceUrl_like	String	Matches `sourceUrl` 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 `sourceUrl`, it can be used for the literal prefix (the part until the first placeholder). The URL for the source documentation.
sourceUrl_lt	String	Checks if `sourceUrl` is less than a specified value. The URL for the source documentation.
sourceUrl_lte	String	Checks if `sourceUrl` is less or equal a specified value. The URL for the source documentation.
sourceUrl_not	String	Checks if `sourceUrl` does not equal a specified string, case-sensitively. The URL for the source documentation.
sourceUrl_not_contains	String	Checks if `sourceUrl` does not contain a specified string, case-sensitively. The URL for the source documentation.
sourceUrl_not_ends_with	String	Checks if `sourceUrl` does not end with a specified string, case-sensitively. The URL for the source documentation.
sourceUrl_not_in	String	Checks if `sourceUrl` is not equal to one of the specified values. The URL for the source documentation.
sourceUrl_not_like	String	Checks if `sourceUrl` 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 URL for the source documentation.
sourceUrl_not_starts_with	String	Checks if `sourceUrl` 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 URL for the source documentation.
sourceUrl_starts_with	String	Checks if `sourceUrl` 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 URL for the source documentation.
type	PatchType	Checks if `type` equals a specified value. If an index exists on `type`, it can be used. The type of patch that was applied.
type_in	PatchType	Checks if `type` is equal to one of the specified values. The type of patch that was applied.
type_not	PatchType	Checks if `type` does not equal a specified value The type of patch that was applied.
type_not_in	PatchType	Checks if `type` is not equal to one of the specified values. The type of patch that was applied.
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: PatchFilter

Related Types

Input Fields