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

Keith Whitby

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!

Mahesh S_y9hwt0

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.