Filter: FindingCommentFilter

Filter type for FindingComment.

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

Input Fields

Name	Type	Description
AND	FindingCommentFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	FindingCommentFilter	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.
commentCreateDate	DateTime	Checks if `commentCreateDate` equals a specified value. If an index exists on `commentCreateDate`, it can be used. The date the comment was created
commentCreateDate_gt	DateTime	Checks if `commentCreateDate` is greater than a specified value. The date the comment was created
commentCreateDate_gte	DateTime	Checks if `commentCreateDate` is greater or equal a specified value. The date the comment was created
commentCreateDate_in	DateTime	Checks if `commentCreateDate` is equal to one of the specified values. The date the comment was created
commentCreateDate_lt	DateTime	Checks if `commentCreateDate` is less than a specified value. The date the comment was created
commentCreateDate_lte	DateTime	Checks if `commentCreateDate` is less or equal a specified value. The date the comment was created
commentCreateDate_not	DateTime	Checks if `commentCreateDate` does not equal a specified value The date the comment was created
commentCreateDate_not_in	DateTime	Checks if `commentCreateDate` is not equal to one of the specified values. The date the comment was created
commentUpdateDate	DateTime	Checks if `commentUpdateDate` equals a specified value. If an index exists on `commentUpdateDate`, it can be used. The date the comment was updated
commentUpdateDate_gt	DateTime	Checks if `commentUpdateDate` is greater than a specified value. The date the comment was updated
commentUpdateDate_gte	DateTime	Checks if `commentUpdateDate` is greater or equal a specified value. The date the comment was updated
commentUpdateDate_in	DateTime	Checks if `commentUpdateDate` is equal to one of the specified values. The date the comment was updated
commentUpdateDate_lt	DateTime	Checks if `commentUpdateDate` is less than a specified value. The date the comment was updated
commentUpdateDate_lte	DateTime	Checks if `commentUpdateDate` is less or equal a specified value. The date the comment was updated
commentUpdateDate_not	DateTime	Checks if `commentUpdateDate` does not equal a specified value The date the comment was updated
commentUpdateDate_not_in	DateTime	Checks if `commentUpdateDate` is not equal to one of the specified values. The date the comment was updated
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
createdBy	UserFilter	Checks if `createdBy` is not null, and allows to filter based on its fields.
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.
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
metadata	String	Checks if `metadata` equals a specified string, case-sensitively. If an index exists on `metadata`, it can be used. See also `like` for a case-insensitive filter. The draft.js parsable metadata for the comment
metadata_contains	String	Checks if `metadata` contains a specified string, case-sensitively. The draft.js parsable metadata for the comment
metadata_ends_with	String	Checks if `metadata` ends with a specified string, case-sensitively. The draft.js parsable metadata for the comment
metadata_gt	String	Checks if `metadata` is greater than a specified value. The draft.js parsable metadata for the comment
metadata_gte	String	Checks if `metadata` is greater or equal a specified value. The draft.js parsable metadata for the comment
metadata_in	String	Checks if `metadata` is equal to one of the specified values. The draft.js parsable metadata for the comment
metadata_like	String	Matches `metadata` 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 `metadata`, it can be used for the literal prefix (the part until the first placeholder). The draft.js parsable metadata for the comment
metadata_lt	String	Checks if `metadata` is less than a specified value. The draft.js parsable metadata for the comment
metadata_lte	String	Checks if `metadata` is less or equal a specified value. The draft.js parsable metadata for the comment
metadata_not	String	Checks if `metadata` does not equal a specified string, case-sensitively. The draft.js parsable metadata for the comment
metadata_not_contains	String	Checks if `metadata` does not contain a specified string, case-sensitively. The draft.js parsable metadata for the comment
metadata_not_ends_with	String	Checks if `metadata` does not end with a specified string, case-sensitively. The draft.js parsable metadata for the comment
metadata_not_in	String	Checks if `metadata` is not equal to one of the specified values. The draft.js parsable metadata for the comment
metadata_not_like	String	Checks if `metadata` 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 draft.js parsable metadata for the comment
metadata_not_starts_with	String	Checks if `metadata` 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 draft.js parsable metadata for the comment
metadata_starts_with	String	Checks if `metadata` 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 draft.js parsable metadata for the comment
text	String	Checks if `text` equals a specified string, case-sensitively. If an index exists on `text`, it can be used. See also `like` for a case-insensitive filter. The text for the comment
text_contains	String	Checks if `text` contains a specified string, case-sensitively. The text for the comment
text_ends_with	String	Checks if `text` ends with a specified string, case-sensitively. The text for the comment
text_gt	String	Checks if `text` is greater than a specified value. The text for the comment
text_gte	String	Checks if `text` is greater or equal a specified value. The text for the comment
text_in	String	Checks if `text` is equal to one of the specified values. The text for the comment
text_like	String	Matches `text` 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 `text`, it can be used for the literal prefix (the part until the first placeholder). The text for the comment
text_lt	String	Checks if `text` is less than a specified value. The text for the comment
text_lte	String	Checks if `text` is less or equal a specified value. The text for the comment
text_not	String	Checks if `text` does not equal a specified string, case-sensitively. The text for the comment
text_not_contains	String	Checks if `text` does not contain a specified string, case-sensitively. The text for the comment
text_not_ends_with	String	Checks if `text` does not end with a specified string, case-sensitively. The text for the comment
text_not_in	String	Checks if `text` is not equal to one of the specified values. The text for the comment
text_not_like	String	Checks if `text` 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 text for the comment
text_not_starts_with	String	Checks if `text` 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 text for the comment
text_starts_with	String	Checks if `text` 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 text for the comment
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)
updatedBy	UserFilter	Checks if `updatedBy` is not null, and allows to filter based on its fields.

This page was generated: 2024-05-17

Filter: FindingCommentFilter

Related Types

Input Fields