Contributors
Get information about the users who have contributed to the content.
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.
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. |