How do I find Find all tasks that are in the backlog for more than 2 weeks using JQL?
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.