ODBC Driver for Jira

Build 22.0.8479

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

CData ODBC Driver for Jira ビュー

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