GuardianUserRoles
Query role change history for a specific guardian user. UserId is required.
Select
The connector uses the Talkdesk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| UserId | = |
| Role | =, IN, IS, IS_NOT, LIKE, CONTAINS, NOT_IN |
| AssignedAt | =, IS, IS_NOT |
| AssignedBy | IS, IS_NOT |
For example, the following query is processed server-side:
SELECT * FROM GuardianUserRoles WHERE UserId = 'value'
The connector pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the connector.
- Role supports the following sort directions: ASC, DESC.
- AssignedAt supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM GuardianUserRoles ORDER BY Role ASC
Columns
| Name | Type | References | Description |
| UserId [KEY] | String | The unique identifier of the guardian user. Required to query roles. | |
| Role | String | The assigned role (e.g. Administrator, Agent). | |
| AssignedAt | Datetime | The timestamp when the role was assigned. | |
| AssignedBy | String | The name of the person who assigned the role. |