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 Jira Views
| Name | Description |
| AdvancedSettings | Query the application properties that are accessible on the Advanced Settings page. |
| ApplicationRoles | Query all application roles. In Jira, application roles are managed using the Application access configuration page. |
| Audit | Query the audit log of your JIRA account. |
| BoardConfiguration | Query the agile Board Configuration in Jira. |
| BoardIssues | Query the agile Board Issues in Jira. |
| BoardSprints | Query the agile Sprints related to a Jira Board. |
| Configuration | Query the available Configurations in JIRA. |
| Dashboards | Query the available Dashboards in JIRA. |
| Epics | Query all the Epics. |
| FavouriteFilters | Query the favourite Filters in JIRA. |
| Fields | Query the available System and Custom Fields in JIRA. |
| Filters | Query the set up Filters in JIRA. This table is not available in JIRA Server. |
| Groups | Query the available Groups in JIRA. |
| IssueAffectedVersions | Query the Affected Versions of an issue in JIRA. |
| IssueChangelogs | Query the available IssueChangelogs in JIRA. |
| IssueComponents | Query the available IssueComponents in JIRA. |
| IssueCustomFieldOptions | Query Issue Custom Field Options in JIRA. This resource is not available in JIRA Server or when using OAuth authentication. Specifying at least CUSTOMFIELDID, or ID is required. |
| IssueCustomFields | Query the available Custom Fields in JIRA. |
| IssueFixVersions | Query the available IssueFixVersions in JIRA. |
| IssueLinks | Query the available IssueLinks in JIRA. |
| IssueLinkTypes | Lists all the issue link types. |
| IssueNavigatorDefaultColumns | Query the default issue navigator columns. |
| IssuePriorities | Query the list of all issue priorities. |
| IssueResolutions | Query the list of all issue resolution values. |
| IssueSubtasks | Query the available IssueSubtasks in JIRA. |
| IssueTransitions | Query the available IssueTransitions in JIRA. |
| MyPermissions | Query the available Permissions of the current user in JIRA. |
| Permissions | Query the available Permissions in JIRA. |
| ProjectCategories | Query all the project categories. |
| ProjectRoles | Query roles for all projects in JIRA. |
| ProjectsIssueTypes | Query the available Issue Types of projects. |
| ProjectTypes | Query the list of all issue priorities. |
| RoleDetails | Query Role Details in JIRA. |
| SecurityLevels | Query all the created security levels. |
| SecuritySchemes | Query all the created security schemes. |
| SprintIssues | Query the agile Sprint Issues in Jira. |
| Statuses | Query the possible Statuses in Jira. |
| TimeTrackingProviders | Query the list of all time tracking providers. |
| Votes | Query the available Votes in JIRA. |
| Watchers | Query the available Watchers in JIRA. |
| Workflows | Query the available Workflows in Jira. |
| WorkflowStatusCategories | Query the list of all status categories. |
| WorkflowStatuses | Query the list of all statuses associated with workflows. |