Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the provider 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 ADO.NET Provider 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. |
| 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. |