Filter: HashFilter

Filter type for Hash.

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


Input Fields

NameTypeDescription
ANDHashFilter

A field that checks if all filters in the list apply

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

ORHashFilter

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.

algHashAlgorithm

Checks if alg equals a specified value.

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

The algorithm used to compute the hash

alg_inHashAlgorithm

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

The algorithm used to compute the hash

alg_notHashAlgorithm

Checks if alg does not equal a specified value

The algorithm used to compute the hash

alg_not_inHashAlgorithm

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

The algorithm used to compute the hash

contentString

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

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

See also like for a case-insensitive filter.

The value of the hash computed using the specified algorithm

content_containsString

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

The value of the hash computed using the specified algorithm

content_ends_withString

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

The value of the hash computed using the specified algorithm

content_gtString

Checks if content is greater than a specified value.

The value of the hash computed using the specified algorithm

content_gteString

Checks if content is greater or equal a specified value.

The value of the hash computed using the specified algorithm

content_inString

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

The value of the hash computed using the specified algorithm

content_likeString

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

The value of the hash computed using the specified algorithm

content_ltString

Checks if content is less than a specified value.

The value of the hash computed using the specified algorithm

content_lteString

Checks if content is less or equal a specified value.

The value of the hash computed using the specified algorithm

content_notString

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

The value of the hash computed using the specified algorithm

content_not_containsString

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

The value of the hash computed using the specified algorithm

content_not_ends_withString

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

The value of the hash computed using the specified algorithm

content_not_inString

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

The value of the hash computed using the specified algorithm

content_not_likeString

Checks if content 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 of the hash computed using the specified algorithm

content_not_starts_withString

Checks if content 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 of the hash computed using the specified algorithm

content_starts_withString

Checks if content 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 of the hash computed using the specified algorithm

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

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 child entity uniquely within this collection of child entities

id_gtID

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_gteID

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_inID

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_ltID

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_lteID

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_notID

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_inID

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

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

updatedAt_gtDateTime

Checks if updatedAt is greater than a specified value.

The instant this object has been updated the last time

updatedAt_gteDateTime

Checks if updatedAt is greater or equal a specified value.

The instant this object has been updated the last time

updatedAt_inDateTime

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

The instant this object has been updated the last time

updatedAt_ltDateTime

Checks if updatedAt is less than a specified value.

The instant this object has been updated the last time

updatedAt_lteDateTime

Checks if updatedAt is less or equal a specified value.

The instant this object has been updated the last time

updatedAt_notDateTime

Checks if updatedAt does not equal a specified value

The instant this object has been updated the last time

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


This page was generated: 2024-11-06