Tracking slippages to Due date in confluence

Question

Ive produced a dashboard in confluence in which i am extracting ticket which have a certain label, and trying to track them against their 'Due Date'.  Is there something in which i can put in the query to move a ticket from the 'On schedule' column to the 'Delayed' column?

Jonathan Rees_7zesuf · Answer

Hi Kris,

Thats correct in that im referring to columns. i might be looking at this wrong but on your queries this would only move if the Status was set up as 'On Schedule', 'Delayed'. Is that right?

Our Statuses are set up: Backlog, Analysis, Analysis done, In Progress, Ready for Prod, Live.

Would that mean i need to change the query?

Kristopher Perez · Answer

label = $label and duedate > startofday() - for the "On Schedule"

label = $label and duedate < startofday() - for the "Delayed"

The above 2 queries should work for you.

I'm assuming that when you are referring to columns, that you are using two separate Jira Gadgets on a Confluence page.

Hope that helps

Kris