nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exclude re-ranked issues from JQL

Bond_rthrlb

Hello,

As the Product Owner, I want to do reviews with my Development Team Lead two times a week, so I can monitor and control the status and action.

I have created the following query:

project = LUNA AND updated >= -5d ORDER BY updated DESC

It works perfect showing me issues which were updated last 5 days, so we focus and discuss updates on those.

The issue is it also showed RE-RANKED issues, i.e. those which didn't change status, didn't get comments updates etc. - but simply were re-ordered in the backlog.

How can I exclude those re-ranked issues from my query please?

Accepted answers

John Funk

Hey Bond - I think the reordering of the issue is technically an update to the issue, therefore it will be included in your query. The trick is to somehow differentiate between the issues that were simply re-ranked with no other updates and the rest.

If you it is just commented stuff that separates it, then maybe something like:

project = LUNA AND commentedOn >= -5d

All comments

Gustav L'Estrade

Hello @Bond,

From a little research it seems to be impossible to exclude ranking from the updated field. It also seems like the ranking-field is unavailable in a JQL query since it will be reweighted automatically in Jira as the number of issues grow/decrease.

My though is, can this be solved with a workflow status? For instance a workflow status might be Open and includes the backlog. When a sprint is active (given that you use Scrum) you transition the issues to a ToDo or similair that indicates that the developers can start working on it. With the above workflow, you can then exclude the Open status from the query, hence elimiting all the issues that were updated in the backlog. A query could be like:

project = LUNA AND updated >= -5d AND status != Open ORDER BY updated DESC

The limitation to this solution is that it will not show work done in the backlog.

Thoughts on the solution?

Hope it helps!

John Funk

If you it is just commented stuff that separates it, then maybe something like:

project = LUNA AND commentedOn >= -5d

Bond_rthrlb

Hello John, thank you for your answer very much. CommentedOn is interesting, I didn't know it exists before! Is there similar thing for status chnage (e.g. from Open to Selected for DEV etc.)

Bond_rthrlb

Hello Gustav, I was thinking to exclude tasks in the status Open/Backlog.

Regarding to your comment that it will not show work done in the backlog - could you please clarify what do you mean?

Gustav L'Estrade

With above JQL i proposed, it filters all tasks that has been updated the last 5 days and that is NOT in the Open status. Since the backlog typically will be the starting point of the workflow (with status Open or alike) and is where the ranking happens, if you exclude the Open status as in the JQL the tasks updated by reranking wont show.

TLDR: If the ranking only happens in the backlog , exclude the status issues have while being in the backlog.

Makes sense?

John Funk

Hi Bond - Yes, there is!

project = LUNA and status changed from "Open" to "Selected for DEV" after startOfDay(-5)

John Funk

@Bond - Did this work for you?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud