Filter: TagFilter

Filter type for Tag.

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


Input Fields

NameTypeDescription
ANDTagFilter

A field that checks if all filters in the list apply

If the list is empty, this filter applies to all objects.

ORTagFilter

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.

colorString

Checks if color equals a specified string, case-sensitively.

If an index exists on color, it can be used.

See also like for a case-insensitive filter.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_containsString

Checks if color contains a specified string, case-sensitively.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_ends_withString

Checks if color ends with a specified string, case-sensitively.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_gtString

Checks if color is greater than a specified value.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_gteString

Checks if color is greater or equal a specified value.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_inString

Checks if color is equal to one of the specified values.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_likeString

Matches color 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 color, it can be used for the literal prefix (the part until the first placeholder).

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_ltString

Checks if color is less than a specified value.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_lteString

Checks if color is less or equal a specified value.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_notString

Checks if color does not equal a specified string, case-sensitively.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_not_containsString

Checks if color does not contain a specified string, case-sensitively.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_not_ends_withString

Checks if color does not end with a specified string, case-sensitively.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_not_inString

Checks if color is not equal to one of the specified values.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_not_likeString

Checks if color 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);

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_not_starts_withString

Checks if color 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.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

color_starts_withString

Checks if color 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.

A color associated with the tag, if any. This is used to visually color the instances of the tag in the UI.

createdAtDateTime

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_gtDateTime

Checks if createdAt is greater than a specified value.

The instant this object has been created

createdAt_gteDateTime

Checks if createdAt is greater or equal a specified value.

The instant this object has been created

createdAt_inDateTime

Checks if createdAt is equal to one of the specified values.

The instant this object has been created

createdAt_ltDateTime

Checks if createdAt is less than a specified value.

The instant this object has been created

createdAt_lteDateTime

Checks if createdAt is less or equal a specified value.

The instant this object has been created

createdAt_notDateTime

Checks if createdAt does not equal a specified value

The instant this object has been created

createdAt_not_inDateTime

Checks if createdAt is not equal to one of the specified values.

The instant this object has been created

createdByUserFilter

Checks if createdBy is not null, and allows to filter based on its fields.

descriptionString

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.

A longer description of the tag

description_containsString

Checks if description contains a specified string, case-sensitively.

A longer description of the tag

description_ends_withString

Checks if description ends with a specified string, case-sensitively.

A longer description of the tag

description_gtString

Checks if description is greater than a specified value.

A longer description of the tag

description_gteString

Checks if description is greater or equal a specified value.

A longer description of the tag

description_inString

Checks if description is equal to one of the specified values.

A longer description of the tag

description_likeString

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).

A longer description of the tag

description_ltString

Checks if description is less than a specified value.

A longer description of the tag

description_lteString

Checks if description is less or equal a specified value.

A longer description of the tag

description_notString

Checks if description does not equal a specified string, case-sensitively.

A longer description of the tag

description_not_containsString

Checks if description does not contain a specified string, case-sensitively.

A longer description of the tag

description_not_ends_withString

Checks if description does not end with a specified string, case-sensitively.

A longer description of the tag

description_not_inString

Checks if description is not equal to one of the specified values.

A longer description of the tag

description_not_likeString

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);

A longer description of the tag

description_not_starts_withString

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.

A longer description of the tag

description_starts_withString

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.

A longer description of the tag

idID

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_gtID

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_gteID

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_inID

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_ltID

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_lteID

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_notID

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_inID

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

nameString

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 text of the tag. This appears in the UI and is what is searched for when filtering.

name_containsString

Checks if name contains a specified string, case-sensitively.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_ends_withString

Checks if name ends with a specified string, case-sensitively.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_gtString

Checks if name is greater than a specified value.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_gteString

Checks if name is greater or equal a specified value.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_inString

Checks if name is equal to one of the specified values.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_likeString

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 text of the tag. This appears in the UI and is what is searched for when filtering.

name_ltString

Checks if name is less than a specified value.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_lteString

Checks if name is less or equal a specified value.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_notString

Checks if name does not equal a specified string, case-sensitively.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_not_containsString

Checks if name does not contain a specified string, case-sensitively.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_not_ends_withString

Checks if name does not end with a specified string, case-sensitively.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_not_inString

Checks if name is not equal to one of the specified values.

The text of the tag. This appears in the UI and is what is searched for when filtering.

name_not_likeString

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 text of the tag. This appears in the UI and is what is searched for when filtering.

name_not_starts_withString

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 text of the tag. This appears in the UI and is what is searched for when filtering.

name_starts_withString

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 text of the tag. This appears in the UI and is what is searched for when filtering.

organizationOrganizationFilter

Checks if organization is not null, and allows to filter based on its fields.

updatedAtDateTime

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_gtDateTime

Checks if updatedAt is greater than a specified value.

The instant this object has been updated the last time (not including relation updates)

updatedAt_gteDateTime

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_inDateTime

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_ltDateTime

Checks if updatedAt is less than a specified value.

The instant this object has been updated the last time (not including relation updates)

updatedAt_lteDateTime

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_notDateTime

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_inDateTime

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)

updatedByUserFilter

Checks if updatedBy is not null, and allows to filter based on its fields.


This page was generated: 2024-11-06