Contributors
Lists the users who have contributed to a specific page or space, providing insight into collaboration and content ownership.
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: Either ContentId, AccountId or ContentType must be specified in order to query the Contributors view.
- ContentId supports the '=,!=,IN,NOT IN' comparisons.
- AccountId supports the '=,IN' comparisons.
- ContentType 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 IN ('12345678', '23456789')
SELECT * FROM Contributors WHERE ContentType = 'page'
SELECT * FROM Contributors WHERE ContentType != 'page'
SELECT * FROM Contributors WHERE ContentType IN ('page', 'attachment')
SELECT * FROM Contributors WHERE ContentType NOT IN ('page', 'attachment')
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 | The unique identifier of the content item that supports contributions, such as a page, blog post, comment, or attachment. This value corresponds to the 'Id' field in related tables like Attachments, Pages, Comments, or Blogposts. | |
| ContentType | String | =,!=,IN,NOT_IN | Specifies the type of content to which the contributor has added input, for example page, comment, or blog post. | |
| UserType | String | Indicates the type of user who contributed, such as internal user, external collaborator, or system account. | ||
| AccountId [KEY] | String | =,IN | The unique account identifier of the contributor, used to link the user to their contributions across Confluence content. |