How do I find Find all tasks that are in the backlog for more than 2 weeks using JQL?

[Vera Valshonok]

How do I find Find all tasks that are in the backlog for more than 2 weeks using JQL?

[Jack Brickey · Accepted solution]

It depends on how issues enter your backlog. Typically this occurs when an issue is created. assuming that try the following

Project = xxxxx and status = "To Do" and createdDate <= startOfDay(-2w)

[Vera Valshonok]

for us tasks can be moved from any status to t he backlog, not just after creation of the task, but fron any status in the sprints, future sprints

[Jack Brickey]

Then you need to find a way to incorporate the date it entered the status associated with backlog and still in that status. This is not simple and I would refer you to an old post that does a good job explaining this. I recommend adding a custom date field (entered backlog) and use a post function to add the current date to the field when an issue transitions into that status. Depending on your needs you may want to clear that field when an issue transitions out of that status as well.