Find risks above certain calculated score

My project has all risks in JIRA, with a calculated score. I would like to query JIRA for all risks above a certain score, but it does not seem to be possible. Any way to do that without a plugin?

risk.PNG

1 answer

0 vote

What type of field is "calculated risk"? 

The search depends on the type of field, as different fields have different ways to search.  A "greater than" search is almost always nonsense for a text type field, and probably should be searched as "alphabetically higher" instead.  Equally, a fuzzy text search on a date is useless, but you would want "earlier/later than" searches.

My guess is your calculated risk is being made searchable as a text field, which isn't going to be useful.  It might be possible to change it, but I don't know without the field type. 

Should be shown next to the field name in the list of custom fields.

Not sure what kind of field it is - it's not displayed in the list of fields. 

calc.PNG

Any other way to check? 

Do you think the "greater than" search would work if this field is defined as a number?

 

Ah, different version of JIRA, the field type should be underneath it. 

If it's still not there, then can you try the "edit" link for the field and see what that says?  And then "configure" if there is the option to do that (some fields don't have configure)

Unfortunately I don't have the admin rights to change these fields it seems. I could contact the platform admins, but I would guess that the field can not be easily changed without affecting everyone else on the platform.

Ah, you'd need admin rights to get into the list of custom fields to see the type as well, that explains why you didn't get it in your screenshot.

I'll try to figure it out with the admins. Thanks for your help.

Yes, I can see it's a bit of a pain.  Without knowing what type of field it is now, I can't really give much guidance - you might be able to change the field template, or the searcher, or you might need to migrate to another field.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

131 views 5 9
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you