Behavior to limit character length and value in a custom text field

[Scott Federman]

Hey all, 

I'm sure this is pretty easy but I'm pretty clueless with scripting. Could someone help me with a behavior that would only allow 2 characters and values of 0-25? Custom Field ID is 11850.

[Hana Kučerová · Accepted solution]

Hi @Scott Federman ,

which type does your custom field have? Is it a Number Field or Text Field (single line)? Thank you.

[Scott Federman]

Hi @Hana Kučerová  its a text field...although i can change it to a number field if need be. 

[Hana Kučerová]

Hi @Scott Federman

the field's type is ok :-).

import com.onresolve.jira.groovy.user.FormField

FormField formField = getFieldById(getFieldChanged())
String value = formField.getValue() as String
if (!value.matches("[0-9]|1[0-9]|2[0-5]")) {
    formField.setError("Your error message")
} else {
    formField.clearError()
}

 Please add it as a server-side script to your customfield and try :-).

[Scott Federman]

 @Hana Kučerová Its close! Its not allowing me to put any number in there at all though.

[Scott Federman · Accepted solution]

@Hana Kučerová i did notice one other problem. It works great on the edit screen, but there is no restriction from the view screen which is allowing me to put any number in the fields via inline editing.

[Hana Kučerová]

@Scott Federman Please check the mapping (issue types, projects) and configuration of your Behaviour. Field's inline edit should not be not possible, when there's a validator, and Jira should automatically open the full edit screen, when you click on the pencil icon.

[Scott Federman]

Interesting. You are correct. I'm not sure what was going on earlier. 

[Hana Kučerová · Accepted solution]

Hi @Scott Federman

did you try to move to another field, after you've entered the correct value (like 14)?

[Scott Federman]

@Hana Kučerová ive tried moving to the next field as well as editing and have had no luck

[Hana Kučerová]

Thanks!

Please try to test this code:

import com.onresolve.jira.groovy.user.FormField

FormField formField = getFieldById(getFieldChanged())
String value = formField.getValue() as String
if (value) {
    if (value != "test") {
        formField.setError("error")
    } else {
        formField.clearError()
    }
} else {
    formField.clearError()
}

Then it should work like this:

• Field is empty -> ok
• Field is filled with some random text -> error
• Field is filled with word test -> ok

Each time you change the value of the field, move to the next field. Then the validator should be called (you can check in browser's console - there should be activity on the Network tab)

Maybe there is something wrong with the regex, but it works for me :-(...

Which version of Jira and ScriptRunner do you have?

[Scott Federman]

@Hana Kučerová here are my results

• If empty then i can update the ticket
• "Error" and error pops saying "Error" is not a valid number
• "Ok an error pops saying  "Ok" is not a valid number.
• Change to a number and it still says "Ok" is not a valid number.

We are using Jira 8.4.1 and scriptrunner 5.6.6.1-jira8

[Hana Kučerová]

@Scott Federman It seems to me, that your custom field must have Number Field type (not Text Field (single line)). Is it possible?

Are there any other behaviours defined for your project?

Thanks.

[Scott Federman]

@Hana Kučerová You know i could have sworn they were text fields but you are correct. They are number fields.

[Hana Kučerová]

@Scott Federman Thing happens :-)...

If it is a number, what about the values like 14.0 ? Are they valid or not? And what about 14.5? Thanks...

[Scott Federman]

Thanks @Hana Kučerová

No need for decimals. Everything will be a whole number.

[Hana Kučerová]

@Scott Federman Last try :-)

import com.onresolve.jira.groovy.user.FormField

FormField formField = getFieldById(getFieldChanged())
String value = formField.getFormValue() as String
if (value) {
    if (!value.matches("[0-9]|1[0-9]|2[0-5]")) {
        formField.setError("Your error message")
    } else {
        formField.clearError()
    }
} else {
    formField.clearError()
}

[Scott Federman]

We have a winner!!!!

Thank you for everything @Hana Kučerová You are a magician. 

[Tomáš Doležel]

Hello @Hana Kučerová
I am also rookie in scripting. I spent hours of time to change if condition for custom field but didn´t find working solution. My condition should be: 

Value of the custom field must contain exact 7 digits (not less, not more, only digits not letters).

Could you help me with this condition please? Thank you very much. 
 

[Hemanth Kumar]

@Hana Kučerová  first of all, thanks for the attempts and patience. Can you please help me understanding below line ?

if (!value.matches("[0-9]|1[0-9]|2[0-5]")) {

 I need to set the limit of an field to accept value only if its between (60 - 8400), this is numeric field these are values in seconds

[Hemanth Kumar]

@Hana Kučerová I was able to create script with some help of google/community and figured out to ranging from 60 to 100, but can you assist how to fix the range to 3 digit and 4 digit value. (as mentioned in above - 60 - 8400 is my requirement)

import com.onresolve.jira.groovy.user.FormField

FormField formField = getFieldById(getFieldChanged())

String value = formField.getFormValue() as String

if (value) {

    if (!value.matches("[6-9][0-9]|100")) {

        formField.setError("value should be bet. 60-8400")

    } else {

        formField.clearError()

    }

} else {

    formField.clearError()

}

[Hana Kučerová]

@Hemanth Kumar 

Please try:

(6[0-9]|[7-9][0-9]|[1-9][0-9]{2}|[1-7][0-9]{3}|8[0-3][0-9]{2}|8400)

[Hemanth Kumar]

@Hana Kučerová  It worked thanks a lot. But i would like to understand the format styling please.

I tried (("[6-9][0-9]|100") && ("[0-9][0-9][0-9]|1000")) assuming - 60 to 100 and 101 to 1000, but it didn't worked.

[Hana Kučerová]

@Hemanth Kumar 

6[0-9] .. 60 - 69

[7-9][0-9] .. 70 - 99

[1-9][0-9]{2} .. 100 - 999

[1-7][0-9]{3} .. 1000 - 7999

8[0-3][0-9]{2} .. 8000 - 8399 

8400 .. 8400

[Hemanth Kumar]

@Hana Kučerová  thanks a lot, it helped

[Kishore D]

Hi @Hana Kučerová ,

Thanks for your script. it worked for me too.

Along with this script, i have extended requirement ie; my text field should not exceed more than 10 characters and it should allow only 0-9 numbers. 

Help required from you:  

import com.onresolve.jira.groovy.user.FormField

FormField formField = getFieldById(getFieldChanged())
String value = formField.getValue() as String
if (!value.matches("[0-9]{1,256}")) {
    formField.setError("Your error message")
} else {
    formField.clearError()
}

 can you tell us how can we add "|" as multiple value separator. 
[0-9]{1,256} is to keep field max length  is 256 characters. we need to modify script as to add "|" as multiple value separator.

Expected:
Field_name= 1234|456|7890|..

can you help?

[Peter Preston]

@Scott Federman - glad you were able to resolve the validation problem. If this is something you need to build often, you could try ProForma (or ProForma Lite - a free version of the app) for a simpler way to build validation. Full disclosure, I'm on the ProForma team.