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?
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
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!
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.
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...
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