Filter: ExternalReferenceFilter

Filter type for ExternalReference.

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

ExternalReference

Input Fields

Name	Type	Description
AND	ExternalReferenceFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	ExternalReferenceFilter	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.
category	ExternalReferenceCategory	Checks if `category` equals a specified value. If an index exists on `category`, it can be used. Specifies the category of the external reference.
category_in	ExternalReferenceCategory	Checks if `category` is equal to one of the specified values. Specifies the category of the external reference.
category_not	ExternalReferenceCategory	Checks if `category` does not equal a specified value Specifies the category of the external reference.
category_not_in	ExternalReferenceCategory	Checks if `category` is not equal to one of the specified values. Specifies the category of the external reference.
comment	String	Checks if `comment` equals a specified string, case-sensitively. If an index exists on `comment`, it can be used. See also `like` for a case-insensitive filter. An optional comment describing the external reference
comment_contains	String	Checks if `comment` contains a specified string, case-sensitively. An optional comment describing the external reference
comment_ends_with	String	Checks if `comment` ends with a specified string, case-sensitively. An optional comment describing the external reference
comment_gt	String	Checks if `comment` is greater than a specified value. An optional comment describing the external reference
comment_gte	String	Checks if `comment` is greater or equal a specified value. An optional comment describing the external reference
comment_in	String	Checks if `comment` is equal to one of the specified values. An optional comment describing the external reference
comment_like	String	Matches `comment` 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 `comment`, it can be used for the literal prefix (the part until the first placeholder). An optional comment describing the external reference
comment_lt	String	Checks if `comment` is less than a specified value. An optional comment describing the external reference
comment_lte	String	Checks if `comment` is less or equal a specified value. An optional comment describing the external reference
comment_not	String	Checks if `comment` does not equal a specified string, case-sensitively. An optional comment describing the external reference
comment_not_contains	String	Checks if `comment` does not contain a specified string, case-sensitively. An optional comment describing the external reference
comment_not_ends_with	String	Checks if `comment` does not end with a specified string, case-sensitively. An optional comment describing the external reference
comment_not_in	String	Checks if `comment` is not equal to one of the specified values. An optional comment describing the external reference
comment_not_like	String	Checks if `comment` 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); An optional comment describing the external reference
comment_not_starts_with	String	Checks if `comment` 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. An optional comment describing the external reference
comment_starts_with	String	Checks if `comment` 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. An optional comment describing the external reference
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
extRefType	ExternalReferenceType	Checks if `extRefType` equals a specified value. If an index exists on `extRefType`, it can be used. Specifies the type of the external reference.
extRefType_in	ExternalReferenceType	Checks if `extRefType` is equal to one of the specified values. Specifies the type of the external reference.
extRefType_not	ExternalReferenceType	Checks if `extRefType` does not equal a specified value Specifies the type of the external reference.
extRefType_not_in	ExternalReferenceType	Checks if `extRefType` is not equal to one of the specified values. Specifies the type of the external reference.
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 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
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 URL to the external reference
value_contains	String	Checks if `value` contains a specified string, case-sensitively. The URL to the external reference
value_ends_with	String	Checks if `value` ends with a specified string, case-sensitively. The URL to the external reference
value_gt	String	Checks if `value` is greater than a specified value. The URL to the external reference
value_gte	String	Checks if `value` is greater or equal a specified value. The URL to the external reference
value_in	String	Checks if `value` is equal to one of the specified values. The URL to the external reference
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 URL to the external reference
value_lt	String	Checks if `value` is less than a specified value. The URL to the external reference
value_lte	String	Checks if `value` is less or equal a specified value. The URL to the external reference
value_not	String	Checks if `value` does not equal a specified string, case-sensitively. The URL to the external reference
value_not_contains	String	Checks if `value` does not contain a specified string, case-sensitively. The URL to the external reference
value_not_ends_with	String	Checks if `value` does not end with a specified string, case-sensitively. The URL to the external reference
value_not_in	String	Checks if `value` is not equal to one of the specified values. The URL to the external reference
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 URL to the external reference
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 URL to the external reference
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 URL to the external reference

This page was generated: 2024-11-06

Filter: ExternalReferenceFilter

Related Types

Input Fields