Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Exclude re-ranked issues from JQL

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?

2 answers

1 accepted

0 votes
Answer accepted
John Funk Community Leader Oct 10, 2019

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

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.)

John Funk Community Leader Oct 17, 2019

Hi Bond - Yes, there is!

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

Like Bond likes this
John Funk Community Leader Oct 18, 2019

@Bond - Did this work for you? 

Fantastic! I did never thought yet I can do such a things with JQL: "status", "changed", "after", "startOfDay" - it did already triggered a lot of interesting use in my head!

And yes, it works - thank you a lot!

John Funk Community Leader Oct 21, 2019

Great! Glad it worked.  :-)

Just because this wasn't mentioned here, this apparently only works if you have the Scriptrunner plugin installed.

Great to know this is possible with this plugin though fellow Mr Funk!

John Funk Community Leader Aug 08, 2020

WOW! Another Funk brother - love to see that!!

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!

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?

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? 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,430 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you