ArchiveIssuesJQL
Archives multiple issues based on a Jira Query Language (JQL) query, allowing bulk archival by filter.
Stored Procedure Specific Information
The execution time of this stored procedure may vary depending on the data processed in the Jira task. If execution exceeds the current Timeout limit, an exception will be thrown. To prevent this, consider increasing the Timeout connection property as needed for your specific use case.
Note: This stored procedure is available only in the Jira Cloud version.
Input
| Name | Type | Required | Description |
| JQL | String | True | The JQL expression used to select the issues to archive. For example, 'project = ABC AND status = Done'. |
Result Set Columns
| Name | Type | Description |
| NumberOfIssuesArchived | String | Returns the number of top-level issues that were successfully archived as a result of the JQL query. |
| NumberOfSubtasksArchived | String | Returns the number of subtasks that were successfully archived as part of the operation. |