AnsweredAssumed Answered

Variable query problem

Question asked by vladg90 on Sep 5, 2013
Latest reply on Sep 11, 2013 by vladg90

I am upgrading from Activiti 5.11 to 5.13 and I have the following problem:
I am using the REST API. In actu_ru_variable and acti_hi_varinst tables, column var_type_  the values for new
process instances that used to be long with Activiti 5.11 are now set as integer, regardless of the form properties
set in workflow definitions. That wouldn't be much of a problem but when I'm querying for process instances using
variable query without specifying the variable type the old process instances(where the values were set as long)
are not found because the querying variable value falls into integer type.
As a workaround I explicitly set the type of starting process instance variables to long in order to do a single query
instead of one for each type (integer and long).

The question is: why is this differentiation between integer and long for query implementation, though the values
are stored in the same column (long_) in the database?

Thanks & Regards,