Approval Workflow Status Selection Filter witin automation rule

[Sven Meier]

Dear all,

I am currently working on an automation's rule. 

The goal is to select all stories, incident fixes and bug fixes (type in (Story, "Incident Fix", "Bug Fix")) which have Ice Tasks

and an Approval ("Approval status[Short text]" is empty).

They must have at least one ice task which has to be in the status solved ("ICE Tasks" in aqlFunction("STATUS = \"Solved (cust.)\"").

If there are more than one Ice Task all of them must be in status solved to be selected AND "ICE Tasks" not in aqlFunction("STATUS != \"Solved (cust.)\"").

new / to be added: The approval must be in the status open. 

Current rule: 
project = "Name" and type in (Story, "Incident Fix", "Bug Fix") and summary !~ "ATS" and "ICE Tasks" in aqlFunction("STATUS = \"Solved (cust.)\"") AND "ICE Tasks" not in aqlFunction("STATUS != \"Solved (cust.)\"") and "Approval status[Short text]" is empty

Now this one is working however it is having performance issues. Jira returns: 
- Jira was slow to respond, because the JQL query returned too many work items. Narrow the scope of this JQL query and try again:

Now my idea was in order to reduce the selection to include the status of the approval on top of filtering for if there is an approval.

I know that the aqlFunction is slow. So, if you have another idea that filters the same thing in a different (faster) method, that would work for me as well.

This picture may help with understanding of the situation. One can see a story, with an ice task in status solved and an approval in status open:



Thanks in advance,

Sven

[Enric Font]

Dear @Sven Meier 

Create an Automation rule that runs when an ICE Task or Approval changes:

• For parent (Story/Incident/Bug): set a checkbox / label / custom field ICE_All_Solved = true when all linked ICE Tasks are in Solved (cust.).
• Clear ICE_All_Solved when any linked ICE Task becomes non-Solved.
• Similarly set Approval_Open = true when approval is Open.

Then your JQL becomes trivial and lightning fast:

project = "Name" AND type IN (Story, "Incident Fix", "Bug Fix")
AND summary !~ "ATS"
AND ICE_All_Solved = true
AND Approval_Open = true