ODBC Driver for Slack

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060