How to create an automation for overdue tasks

[radu ciofu]

Hello,

is there a JQL querry for tasks which have been more than X days in a column in a board?

And can i use it in an automation?

[John McKiernan]

Hey @radu ciofu ,

You actually don't need an app to do this if you are in Jira Cloud. (Atlassian acquired Automation for Jira app and it is now part of Jira Cloud natively)

You can see how a similar rule would look on this page: https://community.atlassian.com/t5/Jira-Software-articles/4-Automation-rules-to-accompany-the-Getting-started-with/ba-p/1346202?lightbox-message-images-1346202=89988i9126A57894999A9C

Just need to use a scheduled rule. If you are a Server user, you can use the same rule but you will need to install the app from the marketplace (there is a free version also)

Hope that helps

John 

[Grigory Salnikov]

Hi @radu ciofu 

Columns are usually based on status so the JQL query should look something like

!(status changed after -Xd)

I'm sure we can automate these task with an app that uses JQL for filtering. How exactly - depends on a tool.

[radu ciofu]

tx.

will test and get back to you