Filter: UserFilter

Filter type for User.

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


Input Fields

NameTypeDescription
ANDUserFilter

A field that checks if all filters in the list apply

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

ORUserFilter

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.

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

deletedAtDateTime

Checks if deletedAt equals a specified value.

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

The date in which the user was deleted from the app

deletedAt_gtDateTime

Checks if deletedAt is greater than a specified value.

The date in which the user was deleted from the app

deletedAt_gteDateTime

Checks if deletedAt is greater or equal a specified value.

The date in which the user was deleted from the app

deletedAt_inDateTime

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

The date in which the user was deleted from the app

deletedAt_ltDateTime

Checks if deletedAt is less than a specified value.

The date in which the user was deleted from the app

deletedAt_lteDateTime

Checks if deletedAt is less or equal a specified value.

The date in which the user was deleted from the app

deletedAt_notDateTime

Checks if deletedAt does not equal a specified value

The date in which the user was deleted from the app

deletedAt_not_inDateTime

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

The date in which the user was deleted from the app

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.

Email address of the user

email_containsString

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

Email address of the user

email_ends_withString

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

Email address of the user

email_gtString

Checks if email is greater than a specified value.

Email address of the user

email_gteString

Checks if email is greater or equal a specified value.

Email address of the user

email_inString

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

Email address of the user

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

Email address of the user

email_ltString

Checks if email is less than a specified value.

Email address of the user

email_lteString

Checks if email is less or equal a specified value.

Email address of the user

email_notString

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

Email address of the user

email_not_containsString

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

Email address of the user

email_not_ends_withString

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

Email address of the user

email_not_inString

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

Email address of the user

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

Email address of the user

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.

Email address of the user

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.

Email address of the user

eulaAcceptedAtDateTime

Checks if eulaAcceptedAt equals a specified value.

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

The date the user accepted the EULA

eulaAcceptedAt_gtDateTime

Checks if eulaAcceptedAt is greater than a specified value.

The date the user accepted the EULA

eulaAcceptedAt_gteDateTime

Checks if eulaAcceptedAt is greater or equal a specified value.

The date the user accepted the EULA

eulaAcceptedAt_inDateTime

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

The date the user accepted the EULA

eulaAcceptedAt_ltDateTime

Checks if eulaAcceptedAt is less than a specified value.

The date the user accepted the EULA

eulaAcceptedAt_lteDateTime

Checks if eulaAcceptedAt is less or equal a specified value.

The date the user accepted the EULA

eulaAcceptedAt_notDateTime

Checks if eulaAcceptedAt does not equal a specified value

The date the user accepted the EULA

eulaAcceptedAt_not_inDateTime

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

The date the user accepted the EULA

groups_emptyBoolean

Checks if groups is an empty list (true) or a non-empty list or null (false).

groups_everyGroupFilter

Makes sure all items in groups match a certain filter.

groups_noneGroupFilter

Makes sure none of the items in groups match a certain filter.

Note that you can specify the empty object for this filter to make sure groups has no items.

groups_someGroupFilter

Makes sure at least one of the items in "groups" matches a certain filter.

Note that you can specify the empty object for this filter to make sure groups has at least one item.

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

legacyDeletedAtDateTime

Checks if legacyDeletedAt equals a specified value.

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

The date in which the user was deleted from the legacy application

legacyDeletedAt_gtDateTime

Checks if legacyDeletedAt is greater than a specified value.

The date in which the user was deleted from the legacy application

legacyDeletedAt_gteDateTime

Checks if legacyDeletedAt is greater or equal a specified value.

The date in which the user was deleted from the legacy application

legacyDeletedAt_inDateTime

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

The date in which the user was deleted from the legacy application

legacyDeletedAt_ltDateTime

Checks if legacyDeletedAt is less than a specified value.

The date in which the user was deleted from the legacy application

legacyDeletedAt_lteDateTime

Checks if legacyDeletedAt is less or equal a specified value.

The date in which the user was deleted from the legacy application

legacyDeletedAt_notDateTime

Checks if legacyDeletedAt does not equal a specified value

The date in which the user was deleted from the legacy application

legacyDeletedAt_not_inDateTime

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

The date in which the user was deleted from the legacy application

organizationOrganizationFilter

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

roleUserRole

Checks if role equals a specified value.

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

The role the user has within the Organization. This field is being deprecated in favor of the roles field.

role_inUserRole

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

The role the user has within the Organization. This field is being deprecated in favor of the roles field.

role_notUserRole

Checks if role does not equal a specified value

The role the user has within the Organization. This field is being deprecated in favor of the roles field.

role_not_inUserRole

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

The role the user has within the Organization. This field is being deprecated in favor of the roles field.

roles_emptyBoolean

Checks if roles is an empty list (true) or a non-empty list or null (false).

roles_everyStringFilter

Makes sure all items in roles match a certain filter.

roles_noneStringFilter

Makes sure none of the items in roles match a certain filter.

Note that you can specify the empty object for this filter to make sure roles has no items.

roles_someStringFilter

Makes sure at least one of the items in "roles" matches a certain filter.

Note that you can specify the empty object for this filter to make sure roles has at least one item.

settingsUserSettingsFilter

Allows to filter on the fields of settings.

Note that settings is an entity extension and thus can never be null, so specifying null to this filter field has no effect.

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)


This page was generated: 2024-10-16