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 driver uses the Slack API to process search criteria that refer to the UserId column. This column supports server-side processing for the = operator. The driver processes other filters client-side within the driver.
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. |