GuardianUserRoles
Query role change history for a specific guardian user. UserId is required.
Select
The add-in 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 add-in.
| 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 add-in pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the add-in.
- 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. |