It's possible to move a issue from the Backlog to the Boad based on the due date?

[Livia Leao Castro]

Hi!

I'm trying to create an automation that is capable of move a issue from the Backlog to the Board (To Do Status) based on the issue due date. It needs to be move 150 days before the due day.

I was trying to create the automation triggin by Schedule. But I'm new on Jira and I don't know how to deal with JQL very well.

[Jack Brickey · Accepted solution]

Hi Livia, welcome to the community! No worries we are all still learning. :-)

so what are you wanting your JQL to represent? Let’s say you want issue that are due in 15d to be moved to the board. The JQL for that would be...

duedate <= startofday(+15d)

now you should also use a condition to verify the issue is not already on the active board as well. I’m not where I can put this together and get the syntax just right but it should look something like this.

trigger = daily

condition - status = to do (or whatever status equates to your backlog

condition - JQL duedate <= startofday(+15d)

action - transition issue to In progress (or whatever status equates to your left most board status)

let me know if you get stuck. I can assist further tomorrow if needed. 

[Livia Leao Castro]

Hi! Tks!

It helps me a lot. I decided to create the condition based on a label. 

But I still cannot move from the backlog to the board. Jira has the option to change the status. But I couldn't found the option to move to a "place" to another. 

[Jack Brickey]

Hi Livia, so i'm not following you about "place". The way you move issues from backlog to the active board is by changing the status. For example if your backlog is made up of To Do status issue and active board is In progress and Done, then you would transition to In Progress.

Note that there is an overlap between the backlog and the active board in that the Kanban backlog will always show all issues that are note Done on the backlog. These issues show at the tope of the backlog separate from the true backlog list.

[Livia Leao Castro]

Hi Jack.

My project don't behave this way. The backlog has a Status. And when I made the automazation to change the status it changed with the issue still in the Backlog. It didn't transfer the issue to the Board. 

There is no overlap as well. The list that is in the backlog are not the same that is in the board.

[Jack Brickey]

So I’m a bit confused by your second image. Your first image seems normal. With the top 4 issues 15, 4, 14, 28 being part of the Kanban board I’m sure if you click on the Kanban board link in the sidebar.  Now your second image is a bit baffling to me it has a title of backlog but a subtitle of “board”. This is not the active Kanban board. At least none that I have ever seen. This appears to be another backlog. I would need to see a more complete images with you sidebar to provide further guidance.