UsersPresence
Query user's presence information. Defaults to the authed user.
Select
You must specify the UserId column in the WHERE clause to query the UsersPresence view. If not specified, the presence information will be fetched for the authed user.
The connector uses the Slack API to process search criteria that refer to the UserId column. This column supports server-side processing for the = operator. The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM UsersPresence WHERE UserId = 'U03AZBU3CMT'
SELECT * FROM UsersPresence WHERE UserId IN ('U03AZBU3CMT', 'U03AZBU3CZH')
Columns
| Name | Type | Description |
| UserId [KEY] | String | The Id of the User. |
| Presence | String | User's current presence (either active or away). |
| Online | Boolean | User's online status. |
| AutoAway | Boolean | User status is away automatically. |
| ManualAway | Boolean | User status is away manually. |
| ConnectionCount | Integer | The connection count. |
| LastActivity | Datetime | Last activity of the user. |