Filter on rank higher than a specific issue

[Johan]

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. 

[Trudy Claspill · Accepted solution]

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]

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.