ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Jira の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずconnector の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにJira から関連するレスポンスデータを返します。
CData Tableau Connector for Jira ストアドプロシージャ
| Name | Description |
| ArchiveIssues | Archives one or more Jira issues by specifying their issue IDs or keys, removing them from active views. |
| ArchiveIssuesJQL | Archives multiple issues based on a Jira Query Language (JQL) query, allowing bulk archival by filter. |
| AssignPermissionScheme | Assigns a specified permission scheme to a Jira project, replacing any existing permissions configuration. |
| ChangeIssueStatus | Performs a workflow status transition on a Jira issue, such as moving from 'To Do' to 'In Progress'. |
| CreateArchivedIssuesExport | Generates a CSV file containing all archived issues and sends a download link to the admin user. |
| CreateCustomField | Creates a new custom field in Jira, which can then be used in issues, screens, or field configurations. |
| CreateSchema | Generates a schema file for a specified table or view, useful for integration or development purposes. |
| DownloadAttachment | Downloads an attachment from Jira by specifying the attachment's unique ID. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Jira. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| GetTimeTrackingSettings | Retrieves the current time tracking configuration settings from the Jira instance. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access token to maintain continuous authenticated access to Jira resources without requiring reauthorization from the user. |
| SelectTimeTrackingProvider | Sets the time tracking provider to be used in Jira, determining how time is recorded and displayed. |
| SetTimeTrackingSettings | Configures time tracking options in Jira, including time formats and default units. |
| UnarchiveIssues | Restores archived issues to active status by specifying their issue IDs or keys. |
| UploadAttachment | Uploads an attachment file to a specific Jira issue, making it visible to users with access to the issue. |