Skip to main content

Flag work that is close to its due date

Show on every work item how many working days are left until its due date or release, and find overdue work with one filter.

Problem: A due date tells you the day, not how much working time is left. You only notice overdue work when someone asks about it.

Solution: You create two Countdown fields from recipes, Days until due and Days to release. They count working days on your calendar, turn negative once the date has passed, and color themselves as the date comes closer.

What you'll need​

  • FieldCraft, installed, with an active license.

  • The Administer Jira global permission, to create the fields.

  • Work items with due dates, or fix versions with release dates.

  • A work calendar with your team's hours. See Create a work calendar.

What your team will experience​

  1. A developer opens a work item due on Friday. Days until due shows 2d 3h left, with the due date under it.

  2. With less than one working day left, the value turns amber. Once the date has passed, it shows 1d 5h overdue in red.

  3. As the project manager, you open the overdue filter each morning and see the most overdue work first.

  4. Finished work keeps how early or late it finished, such as Done 1d early in green.

Set it up​

1. Create Days until due​

  1. Go to Settings (βš™) > Marketplace apps > FieldCraft: Custom Fields. The FieldCraft admin page opens.

  2. On the Fields tab, select New field from recipe. The recipe gallery opens.

  3. Select the Time spent category, then Days until due. The recipe form opens.

  4. Under Working hours, select your team's calendar.

  5. Under Check it on a real work item, enter the key of an open work item with a due date, and select Run preview.

    The Days until due recipe preview for an overdue work item: 18d overdue, -18 working days

  6. Select Create field, then Fill last 90 days.

2. Create Days to release​

  1. Select New field from recipe, then Days to release.

  2. Under Working hours, select the same calendar.

  3. Select Create field, then Fill last 90 days.

Days to release counts to the release date of the work item's earliest unreleased fix version. If none of them has a date, it uses the earliest dated fix version, even a released one. Without a dated fix version, it stays empty.

3. Build the filters​

  1. In Jira's search, run this JQL:

    "Days until due" < 0 AND statusCategory != Done ORDER BY "Days until due" ASC
  2. Save the filter, for example as Overdue.

  3. Run this JQL, and save it as Due within 2 working days:

    "Days until due" >= 0 AND "Days until due" < 2 AND statusCategory != Done
  4. On your dashboard, add a Filter results gadget for each filter.

Keep statusCategory != Done in both filters. Work that finished late keeps its negative number.

To find open work in releases less than 5 working days away, use:

"Days to release" < 5 AND statusCategory != Done ORDER BY "Days to release" ASC

How the countdown keeps moving​

When you open a work item, you always see the current value.

Lists, filters and JQL move forward on their own while Refresh time-based values every hour is on in Settings > Calculation. Values within 7 working days of their date update every hour. Values further away update less often.

Outside working hours, the value stands still, because no working time passes.

A new due date or fix version updates the value within seconds. When you change a version's release date or release it, FieldCraft updates its work items on its own.

Check that it works​

  1. Set the due date of a test work item to tomorrow. Confirm that Days until due shows the time left.

  2. Set the due date to yesterday. Confirm that the value shows overdue, in red, and that the work item is in your Overdue filter.

  3. Move the work item to a Done status. Confirm that it shows how late it finished, such as Done 1d late, and leaves the filter.