Contributors
Get information about the users who have contributed to the content.
Table Specific Information
Select
The connector 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 connector.
Note: ContentId is required in order to query the Contributors view.
- ContentId supports the '=,!=,IN,NOT IN' comparisons.
- AccountId supports the '=,!=,IN,NOT IN' comparisons.
For example, the following queries are processed server side:
SELECT * FROM Contributors WHERE ContentId = '1234'
SELECT * FROM Contributors WHERE ContentId! = '1234'
SELECT * FROM Contributors WHERE ContentId IN ('1234', '2345')
SELECT * FROM Contributors WHERE ContentId NOT IN ('1234', '2345')
SELECT * FROM Contributors WHERE AccountId = '12345678'
SELECT * FROM Contributors WHERE AccountId! = '12345678'
SELECT * FROM Contributors WHERE AccountId IN ('12345678', '23456789')
SELECT * FROM Contributors WHERE AccountId NOT IN ('12345678', '23456789')
Additionally, ContentId column can be used in the ORDER BY clause, as following:
SELECT * FROM Contributors ORDER BY ContentId DESC
Columns
| Name | Type | References | SupportedOperators | Description |
| ContentId [KEY] | String | =,!=,IN,NOT IN | This is the Id of the content that support labels. This can be referenced from Attachments.Id, Pages.Id, Comments.Id or Blogposts.Id. | |
| UserType | String | Type of the contributor. | ||
| AccountId | String | =,!=,IN,NOT IN | Unique account Id of the contributor. NOTE: This column is exclusive to Confluence Cloud. | |
| UserName | String | =,!=,IN,NOT IN | Unique user key of the contributor. NOTE: This column is exclusive to Confluence Server. |