Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,217
Community Members
 
Community Events
168
Community Groups

How to create a Long value Customfield in Jira?

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 Nov 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
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

190 views 1 6
Read article

Atlassian Community Events