Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Jira.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Jira, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Jira Stored Procedures
| Name | Description |
| ArchiveIssues | Archives one or more Jira issues by specifying their issue IDs or keys, removing them from active views. |
| 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'. |
| CreateCustomField | Creates a new custom field in Jira, which can then be used in issues, screens, or field configurations. |
| DeleteAndSwapGroup | Deletes a group and transfers its restrictions to another group. |
| DownloadAttachment | Downloads an attachment from Jira by specifying the attachment's unique ID. |
| GetCurrentUser | Gets the current authenticated user. |
| GetTimeTrackingSettings | Retrieves the current time tracking configuration settings from the Jira instance. |
| 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. |