How do I order JIRAs by most comments made in the search screen?

Question

As subject, I'm guessing I need to use scriptrunner somehow (hascomments) but I don't know how. Help appreciated!

I'm actually looking to see JIRAs with the most activity so it doesn't have to be comments necessarily. It could be number of visits on the JIRA etc. Any advice is appreciated, thanks!

Update: 7 August 2020, I forgot to mention that I am not the JIRA admin so if there is no easy way for a normal user to do this, I think I'll give it a pass.

Phil_a4h2mn · Answer

Thank you all for your answers, it feels like most of the answers require admin assistance. I forgot to mention that I am not the JIRA admin so if there is no easy way for a normal user to do this, I think I'll give it a pass.

Phil_a4h2mn · Answer

"Combining hascomments with aggregatefunction might be able to give you the plain numbers in a search."

Can you show me how to do this?

I am guessing I need to be an admin for the second part of your answer (which I am not).

Nic Brough -Adaptavist- · Answer

With Scriptrunner, there's a couple of options.  Combining hascomments with aggregatefunction might be able to give you the plain numbers in a search.

But I'd be tempted to go the field route.

If you use a plain numeric custom field, you have an instantly searchable and sortable display of "number of comments".  There are too many ways that a Behaviour would skip to populate this, you really need to do the counting in a listener there.

But even more simple would be a scripted field - you barely have to think about:

return (double) commentManager.getComments(issue).size()