User groups.

View Specific Information

Required Scopes

The Scope property must contain the following to have permission to query this view: okta.groups.read

Select

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

• Id supports the '=' and 'LIKE (starts with)' operators
• Created supports the '>', '>=', '=', '<=', and '<' operators
• LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
• LastMembershipUpdated supports the '>', '>=', '=', '<=', and '<' operators
• Type supports the '=' and 'LIKE (starts with)' operators
• ProfileName supports the '=' and 'LIKE (starts with)' operators
• ProfileDescription supports the '=' and 'LIKE (starts with)' operators

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

For example, the following queries are processed server-side:

SELECT * FROM Groups WHERE Id = '00g1emaKYZTWRYYRRTSK'

SELECT * FROM Groups WHERE LastUpdated > '2024-08-01'

Columns