ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Jira の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにJira から関連するレスポンスデータを返します。

CData Excel Add-In for Jira ストアドプロシージャ


Name	Description
AssignPermissionScheme	Assign a permission scheme to a project.
ChangeIssueStatus	Perform a status transition on a specific issue.
CreateCustomField	Use this stored procedure to create a new custom field.
CreateSchema	Creates a schema file for the specified table or view.
DownloadAttachment	Download attachment by specifying its Id.
GetOAuthAccessToken	Gets an authentication token from Jira.
GetOAuthAuthorizationURL	Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the auth token from this URL.
GetTimeTrackingSettings	Sets the time tracking settings.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Jira service.
SelectTimeTrackingProvider	Selects a time tracking provider.
SetTimeTrackingSettings	Sets the time tracking settings.
UploadAttachment	Upload an attachment to a specific Issue.