Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT 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 Power BI Connector 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. |