We have a custom field that gets automatically assigned a value through a workflow post-function. The value is based off the highest existing number in that field in all other tickets in the project. The script is supposed to take the highest value + 1 then add that new number to the new ticket field. However, often that field is being recognized as empty in some tickets, so duplicate values are being assigned when ideally that shouldn't ever happen.
Correct example:
1. custom_field = E100
2. custom_field = E101 (E100 + 1)
3. custom_field = E102 (E101 + 1)
Example of the issue we're experiencing:
1. custom_field = E100
2. custom_field = E101 (E100 + 1)
3. custom_field = E101 (E100 + 1) <-- WRONG
In the issue example, when the query ran for #3 it did not recognize that the value for #2 existed and was the highest value.
Has anyone else experienced a similar issue?
