Resolve JQL Search Error in Jira Automation (Cloud)

要約

Automation rules can also fail after hitting service limits. This article will discuss approaches to avoid service limit throttling due to JQL (Jira Query Language) processing.

診断

The error that can be observed in the audit log of the automation rule is: A JQL search in this automation rule has exceeded the allowed maximum number of work items to retrieve per search. Only the first work items up to the following limit were processed: 1000

原因

The error implies that scheduled JQL (Jira Query Language) search that isn't streamlined enough and returns more than 1000 issues as mentioned in the Service Limit Document.

ソリューション

設定 the JQL query so that the returned search results are narrowed down to a smaller list.

例

Add the specific work item type to narrow the search, put additional conditions if you're looking for specific field values, specify the status, or limit the issue creation date.

サンプル JQL: "Start Date[Date]" < {{now.jiraDate}} AND status != Done AND (Custom_field_XXXX > 0 AND "ABCD_Field" in (Pending))

Additional Information

• JQL 最適化の推奨事項

• Jira クエリ言語 (JQL) で高度な検索を使用する