Filter: UserFilter

Filter type for User.

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

User

Input Fields

Name	Type	Description
AND	UserFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	UserFilter	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.
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
deletedAt	DateTime	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_gt	DateTime	Checks if `deletedAt` is greater than a specified value. The date in which the user was deleted from the app
deletedAt_gte	DateTime	Checks if `deletedAt` is greater or equal a specified value. The date in which the user was deleted from the app
deletedAt_in	DateTime	Checks if `deletedAt` is equal to one of the specified values. The date in which the user was deleted from the app
deletedAt_lt	DateTime	Checks if `deletedAt` is less than a specified value. The date in which the user was deleted from the app
deletedAt_lte	DateTime	Checks if `deletedAt` is less or equal a specified value. The date in which the user was deleted from the app
deletedAt_not	DateTime	Checks if `deletedAt` does not equal a specified value The date in which the user was deleted from the app
deletedAt_not_in	DateTime	Checks if `deletedAt` is not equal to one of the specified values. The date in which the user was deleted from the app
email	String	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_contains	String	Checks if `email` contains a specified string, case-sensitively. Email address of the user
email_ends_with	String	Checks if `email` ends with a specified string, case-sensitively. Email address of the user
email_gt	String	Checks if `email` is greater than a specified value. Email address of the user
email_gte	String	Checks if `email` is greater or equal a specified value. Email address of the user
email_in	String	Checks if `email` is equal to one of the specified values. Email address of the user
email_like	String	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_lt	String	Checks if `email` is less than a specified value. Email address of the user
email_lte	String	Checks if `email` is less or equal a specified value. Email address of the user
email_not	String	Checks if `email` does not equal a specified string, case-sensitively. Email address of the user
email_not_contains	String	Checks if `email` does not contain a specified string, case-sensitively. Email address of the user
email_not_ends_with	String	Checks if `email` does not end with a specified string, case-sensitively. Email address of the user
email_not_in	String	Checks if `email` is not equal to one of the specified values. Email address of the user
email_not_like	String	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_with	String	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_with	String	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
eulaAcceptedAt	DateTime	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_gt	DateTime	Checks if `eulaAcceptedAt` is greater than a specified value. The date the user accepted the EULA
eulaAcceptedAt_gte	DateTime	Checks if `eulaAcceptedAt` is greater or equal a specified value. The date the user accepted the EULA
eulaAcceptedAt_in	DateTime	Checks if `eulaAcceptedAt` is equal to one of the specified values. The date the user accepted the EULA
eulaAcceptedAt_lt	DateTime	Checks if `eulaAcceptedAt` is less than a specified value. The date the user accepted the EULA
eulaAcceptedAt_lte	DateTime	Checks if `eulaAcceptedAt` is less or equal a specified value. The date the user accepted the EULA
eulaAcceptedAt_not	DateTime	Checks if `eulaAcceptedAt` does not equal a specified value The date the user accepted the EULA
eulaAcceptedAt_not_in	DateTime	Checks if `eulaAcceptedAt` is not equal to one of the specified values. The date the user accepted the EULA
groups_empty	Boolean	Checks if `groups` is an empty list (true) or a non-empty list or null (false).
groups_every	GroupFilter	Makes sure all items in `groups` match a certain filter.
groups_none	GroupFilter	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_some	GroupFilter	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.
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 root entity uniquely among others of the same type
id_gt	ID	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_gte	ID	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_in	ID	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_lt	ID	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_lte	ID	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_not	ID	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_in	ID	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
legacyDeletedAt	DateTime	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_gt	DateTime	Checks if `legacyDeletedAt` is greater than a specified value. The date in which the user was deleted from the legacy application
legacyDeletedAt_gte	DateTime	Checks if `legacyDeletedAt` is greater or equal a specified value. The date in which the user was deleted from the legacy application
legacyDeletedAt_in	DateTime	Checks if `legacyDeletedAt` is equal to one of the specified values. The date in which the user was deleted from the legacy application
legacyDeletedAt_lt	DateTime	Checks if `legacyDeletedAt` is less than a specified value. The date in which the user was deleted from the legacy application
legacyDeletedAt_lte	DateTime	Checks if `legacyDeletedAt` is less or equal a specified value. The date in which the user was deleted from the legacy application
legacyDeletedAt_not	DateTime	Checks if `legacyDeletedAt` does not equal a specified value The date in which the user was deleted from the legacy application
legacyDeletedAt_not_in	DateTime	Checks if `legacyDeletedAt` is not equal to one of the specified values. The date in which the user was deleted from the legacy application
organization	OrganizationFilter	Checks if `organization` is not null, and allows to filter based on its fields.
role	UserRole	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_in	UserRole	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_not	UserRole	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_in	UserRole	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_empty	Boolean	Checks if `roles` is an empty list (true) or a non-empty list or null (false).
roles_every	StringFilter	Makes sure all items in `roles` match a certain filter.
roles_none	StringFilter	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_some	StringFilter	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.
settings	UserSettingsFilter	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.
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 (not including relation updates)
updatedAt_gt	DateTime	Checks if `updatedAt` is greater than a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_gte	DateTime	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_in	DateTime	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_lt	DateTime	Checks if `updatedAt` is less than a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_lte	DateTime	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_not	DateTime	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_in	DateTime	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-11-06

Filter: UserFilter

Related Types

Input Fields