Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Database customfield format

Olivier MAZEN
Contributor
July 6, 2018

Hello there,

 

i have probleme with a script validor and custom field format.

i got 2 environement QUAL and PROD.

 

Both of them got the same database. I have initiate the PROD threw a backup file (standard export repository).

 

Actualy i got a Script runner validator on the Create transition to ensure a new issue is not created when there is another issue with the same value in a specific  customfield ( i don't want to get some duplicate issue according specific criteria)

The customfield who validator is based of is a numeric field

 

On QUAL environement its work well.

On PROD it didn't works.

 

When i look the script runner validator log, the value set in my custome field is in "Scientist mode" like 3.12345678E8 and i get an error message like this is not a valid number

 

Do you have any idea ? i have miss something but where ...

 

Regards,

 

Olivier

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 6, 2018

Your "scientist mode" simply means "the number is too long to write out" - in the variable, it's still an exact floating point number.  I suspect your script is taking it as though it's a string though, instead of a number, which won't work.

What is the data in this field?  (Not the value, but what exactly is it for?  Why is the number so large?)

Olivier MAZEN
Contributor
July 9, 2018

Hello Nic,

i think i have found out tue root cause.

My end user fill the field with copy mast from another application (trehw moose click)

the value is not set threw keyboard, i am looking to fix this.

 

Thank for you time 

 

Olivier

Suggest an answer

Log in or Sign up to answer