JDBC Driver for Jira

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462