Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

JQL Searching of numerical custom fields?

I have a field that we have created that is a single select drop down list. Within this list is a series of 12 numbers. I need to be able to search on this field using the ">=" or "<=" operators.

Is this possible? Any thoughts on how to do this?

1 answer

Hi @Laci 

I do not think you can do that with out-of-the-box JQL.  You might be able to type-convert if you have scripting addons from the marketplace.  Or build something using automation rules.

A work-around would be to use a membership test.  For example...

  • If your single-select field contained: 0, 1, 3, 5, 23.7, 50, 1000
  • And you wanted to find >= 5
  • You might search with myField IN (5, 23.7, 50, 1000)

Best regards,
Bill

@Bill Sheboy , thanks. Unfortunately, that is not going to be attainable as our list of numbers is ever growing and changing. We need something that will allow us to use those search operators.

We do have Scriptrunner. I am just not familiar enough with scripting on how to write such a code.

Thanks!

Thanks for clarifying, Laci.  I'm on Cloud, without ScriptRunner, so I am unable to give you ideas on using that tool.

Hopefully another community member from Adaptavist can help.

Derek Fields Community Leader Jul 19, 2021

Using ScriptRunner, you can create a scripted numeric field. The script would simply be

getCustomFieldValue("<field name>").value

 This will give you a field that you can apply the ">" operator to.

Make sure that you set the Searcher to Number in the Custom Field configuration when you create the scripted field. You will also need to reindex so that the index has the values of the custom field.

Like Bill Sheboy likes this

@Derek Fields unfortunately, this does not allow me to create a drop down menu and I don't trust my developers to input things in properly or consistently with just a text field.

 

I also keep getting an error with your code. It gives me a static error as well as just not being able to run it.

Suggest an answer

Log in or Sign up to answer
TAGS

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