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
|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.|