Users
Get information about a user identified.
Table Specific Information
Select
The adapter 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 adapter. 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 | Full name of the specific user. NOTE: This column is exclusive to Confluence Cloud. | |
| 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 | = | 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. |