JQL: is it possible to search by storypoint (numeric field) where there is a dot or comma in valu

[Eric Roetenberg]

Hello,

JQL: is it possible to search by storypoint (numeric field) where there is a dot or comma in the value.

We want in our only whole numbers in the field so no . or , how can I check for this with a JQL script.

Grtz. Eric

[Nic Brough -Adaptavist-]

This does not answer your question ( I'd just say "look for an app that can do this", as @mauricio.groth already said, and of course, mention Scriptrunner because I'm an Adaptavist) but one thing you might want to consider is adding validators to your workflow.

If you create a validator that said simply "fail if <value> != int(<value>)", no-one would be able to progress issues until they'd corrected the data to make it an integer.

[mauricio.groth]

Hi @Eric Roetenberg

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your issues whose storypoint contains a dot or comma.

issue in wildcardMatch("storypoint", ".,*")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício