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

Keith Whitby 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

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 Leaders.
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.

Suggest an answer

Log in or Sign up to answer