ADO.NET Provider for Confluence

Build 21.0.7930

Contributors

Get information about the users who have contributed to the content.

Table Specific Information

Select

The {i 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 {i.

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930