Sort Stories by Epic Due Date in backlog

Question

I have tried to find the answer in already asked questions and tried the query functionality, but cannot seem to find it to this one:

(How) Can I sort the stories in my backlog based on the due date of the Epic to which the story is linked?

Thanks in advance

Caspar Tijssen · Answer

That's quite a good idea @Troy S, thanks. I'll experiment with that a little.

Troy Spetz_46oct3 · Answer

You could try adding Quick Filters to your Planning Board which 'time-slice' the backlog based on due date (e.g. issues 'where duedate <= 1w', etc).

Doing this, you could see which issues in the backlog are not ordered, according to a duedate range (e.g. due in the next 7 days, in the next 14 days, etc).

Note: We don't use due dates on individual issues. As we are a Scrum team with 2-week sprints (so the team decides when to do what within the sprint), we use the text of the Sprint Number (max. 30 chars) to capture 3 important pieces of information:

Calendar Year-Sprint Number (FixVersion, End of Sprint Date)

Using this format, brings a lot of benefits including:

1. I can easily see how many sprints it will take to complete the planned work for the release

2. I can run daily JQL subscriptions to ensure issues are correctly assigned to sprints which are within the FixVersion.

3. I can see when the currently planned 2-weeks of work will be done.

See attached screenshot of our current sprint's Sprint Number text.

Caspar Tijssen · Answer

The second is indeed what I'm looking for, but I'll keep looking ;)  Thanks anyway