Users in an organization.

View Specific Information

Required Scopes

To query this view, Scope must include okta.users.read.

Select

The component uses the Okta API to process WHERE clause conditions built with the following columns and operators.

• Id supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• Activated supports the '>', '>=', '=', '<=', and '<' operators
• Created supports the '>', '>=', '=', '<=', and '<' operators
• LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
• ProfileEmail supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• ProfileFirstName supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• ProfileLastName supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• ProfileLogin supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• ProfileMobilePhone supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• ProfileSecondEmail supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• Status supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
• StatusChanged supports the '>', '>=', '=', '<=', and '<' operators
• TypeId supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators

All other filters are processed client-side within the component.

For example, the following query is processed server-side:

SELECT * FROM Users WHERE Id = '00uip08mzta1JvWRu5d7'

Columns

Name	Type	Description
Id [KEY]	String	Id of the user
Activated	Datetime	When the user was activated
Created	Datetime	When the user was created
LastLogin	Datetime	When the user was last logged in
LastUpdated	Datetime	When the user was last updated
PasswordChanged	Datetime	When the user last changed their password
ProfileEmail	String	Email of the profile
ProfileFirstName	String	First name of the profile
ProfileLastName	String	Last name of the profile
ProfileLogin	String	Login of the profile
ProfileMobilePhone	String	Mobile phone of the profile
ProfileSecondEmail	String	Secondary email of the profile
Status	String	Status of the user
StatusChanged	Datetime	When the user's status was changed
TypeId	String	Type id