Database customfield format

Question

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

Olivier MAZEN · Answer

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

Nic Brough -Adaptavist- · Answer

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?)