UserStatusQueuesReport
Junction table linking User Status entries to Queues. Derived from the Ring Groups field in UserStatusReport, split on '+' delimiter. Rows with null Ring Groups are excluded.
Select
The UserStatusQueuesReport is a report view. The component processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the component defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM UserStatusQueuesReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| UserId [KEY] | String |
UserStatusReport.UserId | The unique identifier of the user. Foreign key to UserStatusReport. |
| StatusStartAt [KEY] | Datetime |
UserStatusReport.StatusStartAt | The start date and time of the status session. Foreign key to UserStatusReport. |
| QueueId [KEY] | String |
Queues.Id | The queue/ring group identifier. Foreign key to Queues. Derived by splitting Ring Groups on '+' delimiter. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |