Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Confluence Views
| Name | Description |
| Attachments | Get information about a specific attachment. |
| AuditRecords | Fetch a paginated list of AuditRecord instances dating back to a certain time. |
| Blogposts | Get information about a specific blogpost. |
| Comments | Get information about a specific comment. |
| Contributors | Get information about the users who have contributed to the content. |
| GroupMembers | Get users of a specific group. |
| Groups | Get information about a specific group. |
| Labels | Get information about the labels that a specific content has. |
| PageAncestors | To look at a page hierarchy including who is the parent page. |
| PageChildrens | To look at a page hierarchy including who is the child page. |
| PageComments | Get comments specific to a page. |
| PageContents | Get content from the page. |
| Pages | Get information about a specific page. |
| Spaces | Returns information about a number of spaces. |
| Users | Get information about a user identified. |
| ViewersAnalytics | Get the total number of distinct viewers a piece of content has. |
| ViewsAnalytics | Get the total number of views a piece of content has. |