Update an issue status through automation after x time has lapsed

[Wynand Bouchaud]

I'm looking to create a rule through Automation, that will update an issue status from 'In Progress' to Pending, once the issue reaches a certain amount of time in one setting. Is this possible, and how do I go about it please? 

Thanks

[Bill Sheboy · Accepted solution]

Hi @Wynand Bouchaud 

To help refine the issues you are finding, you could use the CHANGED operator from JQL in your trigger, perhaps like this:

project = myProjectName AND NOT status CHANGED AFTER -12h AND status = "In Progress"

This would find issues which are "In Progress" and which have been in that status for at least the last 12 hours.  You may adjust the timeframe as desired, using the other time-related JQL functions.  To learn more, please look here: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

Kind regards,
Bill

[Aditya Verma · Accepted solution]

Hi @Wynand Bouchaud ,

Yes it is possible with Automation Rules. You can create a "Scheduled" trigger and configure your JQL Query (which can filter out tickets based on your time requirements). Please refer the screenshot below.

You can also refer the Automation documentation here.

Thanks,
Aditya

[Wynand Bouchaud]

Hi @Aditya Verma , 

thanks so much for your quick response. I've now managed to get that far, but I think my JQL is not liking my parameters being set, per the below screen shot. The issue I'm facing is to ensure that the query runs, and only executes once a ticket is over 6 hrs, but I'm getting the error. Am I doing something wrong, or should I request higher access?

[Wynand Bouchaud]

I've discovered the answer, end should look like this: 

AND status = "In Progress" AND updatedDate <= "-6h"

thanks though @Aditya Verma 

[Anthony Morais]

Hi @Wynand Bouchaud , as the friend said in the previous answer, yes it is possible with the Automation Rules.
Start with a "Scheduled" trigger.
Then, in the example below, I created a filter with a project created greater than or equal to 6 hours and with a status of Work in progress.

Then add "Transition Issue" action to Pending status.

If it works please mark as accepted answer.

Thanks!

[Aditya Verma]

@Wynand Bouchaud Glad that you were able to do it.