Filter: AuthorFilter

Filter type for Author.

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


Input Fields

NameTypeDescription
ANDAuthorFilter

A field that checks if all filters in the list apply

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

ORAuthorFilter

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.

authorTypeAuthorType

Checks if authorType equals a specified value.

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

The type of the author

authorType_inAuthorType

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

The type of the author

authorType_notAuthorType

Checks if authorType does not equal a specified value

The type of the author

authorType_not_inAuthorType

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

The type of the author

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

emailString

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

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

See also like for a case-insensitive filter.

The email of the author

email_containsString

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

The email of the author

email_ends_withString

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

The email of the author

email_gtString

Checks if email is greater than a specified value.

The email of the author

email_gteString

Checks if email is greater or equal a specified value.

The email of the author

email_inString

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

The email of the author

email_likeString

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

The email of the author

email_ltString

Checks if email is less than a specified value.

The email of the author

email_lteString

Checks if email is less or equal a specified value.

The email of the author

email_notString

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

The email of the author

email_not_containsString

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

The email of the author

email_not_ends_withString

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

The email of the author

email_not_inString

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

The email of the author

email_not_likeString

Checks if email 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 email of the author

email_not_starts_withString

Checks if email 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 email of the author

email_starts_withString

Checks if email 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 email of the author

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

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 full name of the author

name_containsString

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

The full name of the author

name_ends_withString

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

The full name of the author

name_gtString

Checks if name is greater than a specified value.

The full name of the author

name_gteString

Checks if name is greater or equal a specified value.

The full name of the author

name_inString

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

The full name of the author

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 full name of the author

name_ltString

Checks if name is less than a specified value.

The full name of the author

name_lteString

Checks if name is less or equal a specified value.

The full name of the author

name_notString

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

The full name of the author

name_not_containsString

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

The full name of the author

name_not_ends_withString

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

The full name of the author

name_not_inString

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

The full name of the author

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 full name of the author

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 full name of the author

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 full name of the author

phoneString

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

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

See also like for a case-insensitive filter.

The phone number listed by the author

phone_containsString

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

The phone number listed by the author

phone_ends_withString

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

The phone number listed by the author

phone_gtString

Checks if phone is greater than a specified value.

The phone number listed by the author

phone_gteString

Checks if phone is greater or equal a specified value.

The phone number listed by the author

phone_inString

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

The phone number listed by the author

phone_likeString

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

The phone number listed by the author

phone_ltString

Checks if phone is less than a specified value.

The phone number listed by the author

phone_lteString

Checks if phone is less or equal a specified value.

The phone number listed by the author

phone_notString

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

The phone number listed by the author

phone_not_containsString

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

The phone number listed by the author

phone_not_ends_withString

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

The phone number listed by the author

phone_not_inString

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

The phone number listed by the author

phone_not_likeString

Checks if phone 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 phone number listed by the author

phone_not_starts_withString

Checks if phone 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 phone number listed by the author

phone_starts_withString

Checks if phone 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 phone number listed by the author

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