The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I sort by the count of items checked in a select list?

Keith Whitby
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 28, 2016

I'm using a "Select List (multiple choices)" custom field in issues to tag which customers have requested a feature, and I would like to be able to sort the list of feature requests by the amount of customers selected from the list. I'm struggling to find the JQL which would do this.

This would help prioritize which features to build (when combined with the potential impact of the feature). Thanks!

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Mahesh S
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
November 28, 2016

You can use javascript on page load to achieve this. Use different JQLs for each value and fetch the count of results. Based on those values, sort the field value by getting the element Id of the field.

But, if the list is large, it take may take some time for each JQL.