JIRA Automation using JQL not applying for all JQL results

Question

Hello,

I have a JIRA automation setup in my DC instance of JIRA and the automation is pretty straightforward, it runs a JQL every hour, and for any result, it triggers a transition:

The transition has no conditions or validators, it is accessible from all statuses for the issuetype I'm searching for.

The JQL on my testing returned 18 issues, when the automation runs, only 15 issues get transitioned, if I re-run the automation again, the remaining 3 will get picked up and transitioned, I've attached a screenshot below of my automation's log, these runs were triggered back to back manually.

Any guidance on why this could be happening would be greatly appreciated!

Pierre Ibrahim · Answer

Hi there,

Thank you so much for responding, I greatly appreciate it! I tried running the JQL a bunch of times to make sure I'm always getting the same results, even when I "validate jql" in the trigger, I always got 18 issues.

I am able to re-test this as many times as I wish since the automation puts the tickets to "In Progress", and all I need to do to get them back on the JQL is to set them to done.

Worth noting that this is a test environment, so no one else was touching these tickets as I was working on the automation.

Thank you

Pierre Ibrahim · Answer

Hi there,

Absolutely, and thank you so much for responding, I greatly appreciate it!

The JQL is below:

project = OGCI and issuetype = Story and resolution is not empty and (issueFunction in linkedIssuesOf("resolution = Unresolved", "is depended on by") OR issueFunction in linkedIssuesOf("resolution = Unresolved", "blocks") OR issueFunction in linkedIssuesOf("resolution = Unresolved", "is child of") OR issueFunction in parentsOf("resolution = Unresolved")) and (issueLinkType in ("is dependent on","is blocked by","is parent of") or issueFunction in hasSubtasks())

The purpose of it is to find Stories that are resolved yet that have one of three types of links or subtasks that are not resolved. You would need the scriptrunner plugin to get access to the issuefunctions in my JQL.

Thank you!

Craig Nodwell_7eve9b · Answer

Hi @Pierre Ibrahim this is very interesting.  Your jql gets cut off can you send another shot of that.  I'd like to try and mimic this behavior in my test instance as it doesn't look complicated.  Maybe there's more to what @Joseph Chung Yin is leading to above.