Transition Feature to Complete If After Date

Question

I would like to create an automation that does the following:

* Run every morning at 9am
* For features that are part of the "Out of Office" Epic, if due date or end date is in the past (i.e. earlier than today's date), transition feature to "Test Complete"

I've already started building this out where I use "Scheduled" to make this occur at 9am every day. My final step of the automation rule is "Then: Transition the issue to Test Complete", but I'm having trouble getting it to work with the intermediary criteria (bullet #2 above).

Thanks in advance!

Bill Sheboy · Answer

Short answer: no, JQL is needed.

The scenario you are trying to solve seems to be this:

GIVEN there is an epic named "Out of Office"
AND that epic has child features with Due Date values
WHEN such a feature's Due Date is before 9 am today (i.e., it is late)
AND the feature is not already completed or in "Test Complete"
THEN transition the feature to "Test Complete"

Every part of that needs JQL except the THEN.

The question is how "static" do you want it to be.  If you already know the key for the Epic, the scheduled trigger could use this JQL, substituting in your project and the key.

project = yourProject
 AND parent = keyForTheOutOfOfficeEpic
 AND issueType = Feature
 AND duedate < now()
 AND status NOT IN ("Done", "Test Complete" )
 ORDER BY Key ASC

Then the rule would just be the trigger and the issue transition.  I recommend changing the status check to better match your scenario.

Learning how to write and improve JQL is a valuable skill for working with Jira.  I recommend working with your Site Admin to learn more, and perhaps trying this free training and documentation from Atlassian:

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql
https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

Samuel Gatica _ServiceRocket_ · Answer

Hi @Rachel Stein

As far as I know, the most straightforward approach is to use JQL.

In your case, please modify the JQL to parent = "EPIC_KEY," where EPIC_KEY corresponds to the epic name "Out of Office." After making this adjustment, it should function as intended.

Best regards

Sam

Rachel Stein_h5qqde · Answer

Thanks Bill. I'm struggling with getting this to work with JQL. Is there any way to do this using without JQL?