Filter: KeyValuePairFilter

Filter type for KeyValuePair.

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

KeyValuePair

Input Fields

Name	Type	Description
AND	KeyValuePairFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	KeyValuePairFilter	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
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 child entity uniquely within this collection of child entities
id_gt	ID	Checks if `id` is greater than a specified value. An auto-generated string that identifies this child entity uniquely within this collection of child entities
id_gte	ID	Checks if `id` is greater or equal a specified value. An auto-generated string that identifies this child entity uniquely within this collection of child entities
id_in	ID	Checks if `id` is equal to one of the specified values. An auto-generated string that identifies this child entity uniquely within this collection of child entities
id_lt	ID	Checks if `id` is less than a specified value. An auto-generated string that identifies this child entity uniquely within this collection of child entities
id_lte	ID	Checks if `id` is less or equal a specified value. An auto-generated string that identifies this child entity uniquely within this collection of child entities
id_not	ID	Checks if `id` does not equal a specified value An auto-generated string that identifies this child entity uniquely within this collection of child entities
id_not_in	ID	Checks if `id` is not equal to one of the specified values. An auto-generated string that identifies this child entity uniquely within this collection of child entities
key	String	Checks if `key` equals a specified string, case-sensitively. If an index exists on `key`, it can be used. See also `like` for a case-insensitive filter. The key value
key_contains	String	Checks if `key` contains a specified string, case-sensitively. The key value
key_ends_with	String	Checks if `key` ends with a specified string, case-sensitively. The key value
key_gt	String	Checks if `key` is greater than a specified value. The key value
key_gte	String	Checks if `key` is greater or equal a specified value. The key value
key_in	String	Checks if `key` is equal to one of the specified values. The key value
key_like	String	Matches `key` 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 `key`, it can be used for the literal prefix (the part until the first placeholder). The key value
key_lt	String	Checks if `key` is less than a specified value. The key value
key_lte	String	Checks if `key` is less or equal a specified value. The key value
key_not	String	Checks if `key` does not equal a specified string, case-sensitively. The key value
key_not_contains	String	Checks if `key` does not contain a specified string, case-sensitively. The key value
key_not_ends_with	String	Checks if `key` does not end with a specified string, case-sensitively. The key value
key_not_in	String	Checks if `key` is not equal to one of the specified values. The key value
key_not_like	String	Checks if `key` 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 key value
key_not_starts_with	String	Checks if `key` 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 key value
key_starts_with	String	Checks if `key` 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 key value
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
updatedAt_gt	DateTime	Checks if `updatedAt` is greater than a specified value. The instant this object has been updated the last time
updatedAt_gte	DateTime	Checks if `updatedAt` is greater or equal a specified value. The instant this object has been updated the last time
updatedAt_in	DateTime	Checks if `updatedAt` is equal to one of the specified values. The instant this object has been updated the last time
updatedAt_lt	DateTime	Checks if `updatedAt` is less than a specified value. The instant this object has been updated the last time
updatedAt_lte	DateTime	Checks if `updatedAt` is less or equal a specified value. The instant this object has been updated the last time
updatedAt_not	DateTime	Checks if `updatedAt` does not equal a specified value The instant this object has been updated the last time
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
value	String	Checks if `value` equals a specified string, case-sensitively. If an index exists on `value`, it can be used. See also `like` for a case-insensitive filter. The value associated to the key
value_contains	String	Checks if `value` contains a specified string, case-sensitively. The value associated to the key
value_ends_with	String	Checks if `value` ends with a specified string, case-sensitively. The value associated to the key
value_gt	String	Checks if `value` is greater than a specified value. The value associated to the key
value_gte	String	Checks if `value` is greater or equal a specified value. The value associated to the key
value_in	String	Checks if `value` is equal to one of the specified values. The value associated to the key
value_like	String	Matches `value` 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 `value`, it can be used for the literal prefix (the part until the first placeholder). The value associated to the key
value_lt	String	Checks if `value` is less than a specified value. The value associated to the key
value_lte	String	Checks if `value` is less or equal a specified value. The value associated to the key
value_not	String	Checks if `value` does not equal a specified string, case-sensitively. The value associated to the key
value_not_contains	String	Checks if `value` does not contain a specified string, case-sensitively. The value associated to the key
value_not_ends_with	String	Checks if `value` does not end with a specified string, case-sensitively. The value associated to the key
value_not_in	String	Checks if `value` is not equal to one of the specified values. The value associated to the key
value_not_like	String	Checks if `value` 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 value associated to the key
value_not_starts_with	String	Checks if `value` 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 value associated to the key
value_starts_with	String	Checks if `value` 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 value associated to the key

This page was generated: 2024-11-06

Filter: KeyValuePairFilter

Related Types

Input Fields