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; } } }

Filter on rank higher than a specific issue

Johan_rifxqp

Is it possible to create a JQL query that only show results with a higher rank than a specific issue?

What I would like to achieve is to create a filter based on a label like:

project = "MyProject" AND labels="MyLabel" ORDER BY Rank - but also be able to limit the result to issues that fulfills the condition that the Rank is higher than the Rank of a specific issue.

Accepted answers

Trudy P Claspill

Hello @Johan

Welcome to the community.

There is not support for anything like

Rank > (RankofIssue(ABC-123))

Ranking in Jira is not a strictly numeric, sequential element. Instead it is an alphanumeric code. Refer to these two articles:

https://www.jirastrategy.com/questions/how-does-jira-issue-ranking-work

https://tmcalm.nl/blog/lexorank-jira-ranking-system-explained/

The closest thing I have found is this other post where a user got the specific Rank value of an issue and used that in their filter.

https://community.atlassian.com/t5/Jira-questions/How-to-search-for-issues-by-rank-with-JQL/qaq-p/584746

However, every time to re-prioritize issues in your backlog the Rank values in the issues would change, so this type of query would break and you would have to keep fixing it.

All comments

Trudy P Claspill

Hello @Johan

Welcome to the community.

There is not support for anything like

Rank > (RankofIssue(ABC-123))

Ranking in Jira is not a strictly numeric, sequential element. Instead it is an alphanumeric code. Refer to these two articles:

https://www.jirastrategy.com/questions/how-does-jira-issue-ranking-work

https://tmcalm.nl/blog/lexorank-jira-ranking-system-explained/

The closest thing I have found is this other post where a user got the specific Rank value of an issue and used that in their filter.

https://community.atlassian.com/t5/Jira-questions/How-to-search-for-issues-by-rank-with-JQL/qaq-p/584746

However, every time to re-prioritize issues in your backlog the Rank values in the issues would change, so this type of query would break and you would have to keep fixing it.

Bill Sheboy

Hi @Johan -- Welcome to the Atlassian Community!

Yes, and...to what Trudy notes:

You certainly could capture the Rank value for a specific issue and test with a query for items with a lower value, and that would need to be updated whenever Rank changes.

How often do you need to do this and why? Would just using ORDER BY Rank and looking higher in the list work?

If not...and you need this often...and an email list would suffice, you could build an automation rule to do this, sending you an email/message for those issues.

trigger: manual
action: lookup issues with JQL on issues ranked higher than the triggering issue's Rank. This would be limited to 100 returned issues.
action: send an email with the listed issues

Best regards,
Bill

Johan_rifxqp

Thanks! The use-case is to build a dashboard with the "Filter results" gadget. So was looking for a solution a la "Rank > (RankofIssue(ABC-123))" that would be automatic and not break when reordering things, so unfortunately an email list is not good enough for my purpose.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud