ビュー
ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。
ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。
ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。
CData Excel Add-In 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. |