JDBC Driver for Confluence

Build 22.0.8462

Users

Get information about a user identified.

Table Specific Information

Select

The driver will use the Confluence API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver. You can also search for Attachments using CQL (Confluence Query Language).

  • AccountId supports the '=,!=,IN,NOT IN' comparisons.
  • PublicName supports the '=,LIKE,NOT LIKE' comparisons.

For example, the following queries are processed server side:

SQL


SELECT * FROM Users WHERE AccountId = '1234'

SELECT * FROM Users WHERE AccountId IN ('1234','2345')

SELECT * FROM Users WHERE PublicName = 'confluenceuser'

CQL

Note: Filtering with CQL has the highest priority and all the other filters except "Excerpt" will be ignored when CQL filter is present in the query.

SELECT * FROM Users WHERE CQL = 'user.userKey = "4028d6096b696826016b696960860000" AND type = user' AND UserName = 'currentUser()'

Columns

Name Type References SupportedOperators Description
AccountId [KEY] String =,!=,IN,NOT IN Unique account id for the specific user. NOTE: This column is exclusive to Confluence Cloud.
AccountType String Type of the account for the specific user. NOTE: This column is exclusive to Confluence Cloud.
PublicName String =,LIKE,NOT LIKE Full name of the specific user. NOTE: This column is exclusive to Confluence Cloud.
Email String Email of the specific user. NOTE: This column is exclusive to Confluence Cloud.
UserKey [KEY] String =,!=,IN,NOT IN Unique key for the specific user. NOTE: This column is exclusive to Confluence Server.
UserName String =,CONTAINS User name of the specific user. NOTE: This column is exclusive to Confluence Server.
Status String Status of the specific user. NOTE: This column is exclusive to Confluence Server.
Type String Type of the specific user.
Excerpt String Excerpt of the user.
ProfilePicturePath String Path of the profile picture file.
ProfilePictureWidth Integer Profile picture width.
ProfilePictureHeight Integer Profile picture height.
IsDefaultPicture Boolean Indicator showing if the profile picture is never changed.
DisplayName String Display name of the specific user.
Url String Url of the user profile.
LastModified Datetime Last modified timestamp of the user information.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CQL String CQL (Confluence Query Language) allows you to build structured queries.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462