topic Re: Variable query problem in Alfresco Archive

Variable query problem

vladg90 — Thu, 05 Sep 2013 07:00:22 GMT

Hi,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 newprocess instances that used to be long with Activiti 5.11 are now set as integer, regardless of the form properti

Re: Variable query problem

trademak — Fri, 06 Sep 2013 17:32:47 GMT

Hi,

In the variable query the type is also checked. So although the value is stored in the same column the type is different for integer and long. But I agree that there's room for improvement there. Could you create a JIRA issue for this?

Best regards,

Re: Variable query problem

vladg90 — Wed, 11 Sep 2013 10:21:29 GMT

Hi,

I created the JIRA issue: http://jira.codehaus.org/browse/ACT-1787

Thanks & Regards,
Vlad

Re: Variable query problem

frederikherema1 — Wed, 02 Oct 2013 10:54:59 GMT

I don't really agree with leaving out the type-check. With custom variables types (eg. JPAVariable) the long-column (and other columns) can also be used. If the long-column is used by a custom variable, it's possible that the values stored in there don't correspond to an actual "long" or "int" value, rather are an ID of a referenced entity. So leaving out the type-comparison could introduce issues with these kind of variables.
Also, this whould also falsely report results, in case you query for "0" and "1" values, in relation to booleans, which also use a numeric representation in the database.