How to create a Long value Customfield in Jira?

Ahmad Awadallah April 17, 2017

Hi,

I create a Number customfield and trying to store a Long value to it.  When this occurs I get the following:

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,16801][issue,140435][id,9209080][numbervalue,1.5146784E12] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Out of range value for column 'NUMBERVALUE' at row 1))

I can't find a customfield that will store Long value.  I need to store this Long date and then was going to run a calcuated field to take this Long number and convert it to a date.  

Any ideas?

Thank you.

1 answer

0 votes
M Amine
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 23, 2021

I would recommend using a text field and use scriptrunner behaviour in order to check typed value

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events