Automation: Rule to change workflow status

[Christopher Lew]

I'm trying to create a rule that can change the Service Request Status based on a set criteria. When the status is Canceled or Resolved, wait 7 days and then transition to Closed, as per the below Workflow.

I can filter out the results using a JQL query and only return the ones I want, below is the example I'm trying to change using the transition action.

It is from here I get stuck trying to change the status to Closed, any advise on is this the correct action to be using, and how to find the status as it isnt showing a field just as Status. Is the "Copy from trigger issue" correct, and where to find the status field to change?

[Christopher Lew · Accepted solution]

Thanks for the suggestions and assistance, I was able to greatly improve the efficiency of the scheduled task by your advice and figured out the solution to move the issues to the required status via the below screenshots. In addition rather than using the last updated field, we created an End Date field when it reached the final status and use this when looking to auto close. 

[Jack Brickey]

Hi @Christopher Lew , welcome to the community.

A question for you, why are you declaring the issue (AG-264) in your JQL? I think the solution is much simpler than presented unless I am missing something. Below is an example. I use the Scheduled daily trigger and the key is to tick the box "Run a JQL search and...". Then your JQL, I think, would be - status in (resolved, cancelled) and type = service request and updated < startOfDay(-7)

[Christopher Lew]

I'm selecting AG-264 just for my testing phase to see how i can change the workflow status. When deployed this condition will be removed and the updated < startOfDay(-7) will be added in.

[Trudy Claspill]

Hello @Christopher Lew 

Welcome to the Atlassian community.

Can you show us the details of the Scheduled trigger?

What version of Jira are you using? And is it Server or Data Center?

You should not need to have a For branch within this rule. You should be able to select your issues using JQL in the Schedule trigger and then simply follow that with the Transition Issue action. The JQL in the Trigger would look like this:

project=XXX and status in (Resolved,Cancelled) and not status changed after -7d

Replace "XXX" with the name or key for your project.

For the Transition Issue action you would select the option for Selecting a specific transition

(My response is based on functionality available with Jira Data Center v9.10)

[Christopher Lew]

I've got it to schedule once a day and then perform a JQL query, though from another response and yours  I can see i can do that in the schedule function. 

I believe I am using a Data Centre version, as the URL doesn't have Atlassian in it. 

My transition issue action doesnt have the option to change from destination status to specific transition. 

I'll try find the version i'm using