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

How can I incorporate GreenHopper Rank custom forms into searches/filters?

I need to filter my issues based on a number of fields, including GH rank fields. I have a rank field for each department, so for example, I want a filter that shows all items ranked #1 for 3 different departments, each of which has its own rank field.

1 answer

1 accepted

You can't use the GH rank field for filtering AFAIK, just for sorting. The actual value will be a large, arbitrary number. Unfortunately there is no top(n) operator like you have in sql in jql, so I can't see how you can have a query that returns the top 3 ranked issues per department or something else.

Also my understanding is you should have only one global rank field, there is no need to have a rank field per department.

Sorry, I don't know what AFAIK is. Here's the scenario in more detail:

I'm using a project to manage a backload of enhancement requests. Each department requests enhancements. A particular enhancement might be a top priority for Dept 1, but a #5 priority for Dept 2. The only way I'm aware of (and I'm new to JIRA/GH) is to create a rank field for each dept. Then they can use the planning board with a filter applied to see only issues that they care about (managed through a different custom field) and rank them. I set the sort order to be the Dept's rank field, so they can rank the issues as they see fit without impacting overall rank.

Let me know if this makes sense, if you need more info, or if (hopefully!) there's a better/simpler way to do this. Thanks.

You may be entering into the realms of having to create your own jira report.

Hrm, if that's your need, then your way is the only of doing it AFAIK (as far as I know).

I really don't think you can do this with jql, but maybe a jql expert will chime in.

Thanks, I'll take a look at the JIRA report link in just a bit. Here's the link to the page that made me think i COULD filter based on GH ranks:

Specifically the sentence that says "You need to manually update any saved JIRA filters that include the GreenHopper Rank custom field to use the new GreenHopper Global Rank field(s)."

Maybe i'm mis-interpreting that sentence?

Could be referring to using it for ordering... which imho is the only thing it can be used for in filters.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Feb 26, 2019 in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

1,111 views 1 13
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you