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

Order by count of items in custom field

Does anyone have a solution for the following situation?

We are using an internal 'Icebox' backlog for customer and employee product feature requests that the product owners review to determine items that should be prioritized and moved into their actual backlogs.

We have created a custom mutli-select field where every customer is listed. When a request comes in from a customer, we mark that customer in the custom field. If more than one customer is requesting the same feature, we mark them both off in that custom field (since it's multi-select) or merge issues together that could be combined and make sure that each customer is checked off in that custom field.

Anyway, we want to be able to sort based on the count of items checked off in that custom field. Based on what I've read so far, Jira cannot do this.

I'd like to be able to make this happen without having to manually update another field every time we mark off another customer (which seems like an easy-to-implement-but-pain-in-the-butt workaround.)

We do have JiraAutomation, but I'm not sure if it would be able to recognize the custom field item count increasing and automatically update a numerical custom field based on that.

I figured I'd put this question out to the community in case anyone else has solved it, or has an idea :)

1 answer

1 accepted

0 votes
Answer accepted

I figured it out in automation using their smartvalues!

 

Trigger action: when values changes for (first custom field with the drop down that we wanted to count)

Then: Edit issue for (a custom field to house the count number)
value= {{issue.customfield_XXXX.size}}

 

I guess if anyone else ever comes across this, here ya go :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

231 views 1 2
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you