Jira time estimate out of range

[Youssef Bouchara]

Hi everyone, the time estimate in Jira for the issues is causing us some issue because in the Database the column timeestimate is an Integer so it only takes values up to 2,147,483,647 but someone put 99999h as a time estimate (max you can put for an issue) and when it's being converted to seconds it is 3,599,999,640 so it's more than the max Integer value. Now I want to just check for user  Input on jira once someone exceeds that integer limit it should give a warning. How do i proceed?

Thank you guys 

[Daniel Ebers · Accepted solution]

Hi @Youssef Bouchara

while I am not sure if I can follow the part for the integer (as it was possible to put in more than the mentioned 99999h in a Cloud instance as well as on a Jira server - haven't had a look into the Jira server's database though):

... the general request for a sanity check could likely be addressed by a validator.
Remembering a good discussion over here could help you getting a first idea:

• Workflow Regex Validation For Duration/Estimate/Time tracking Custom Field
  https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Workflow-Regex-Validation-For-Duration-Estimate-Time-tracking/qaq-p/1637309

Regards,
Daniel