Users
Get information about a user identified.
Table Specific Information
Select
The add-in 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 add-in. 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. |