topic Re: var_type in the act_hi_detail table always 'string' in Alfresco Archive

var_type in the act_hi_detail table always 'string'

troy_doty — Thu, 12 Dec 2013 21:56:16 GMT

I am trying to understand why this column's value is always null. I was hoping that the data type would key off of the FormData's type. However, even if I have a variable set to a "date", it will insert "string" as the type. I'm not concerned with the value always going in the text column, but I'

Re: var_type in the act_hi_detail table always 'string'

martin_grofcik — Fri, 13 Dec 2013 07:42:20 GMT

Hi Troy.

Following test shows how variables are handled in activiti.
https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/test/java/org/activiti/examples/variables/VariablesTest.java?source=cc

There are different types in the type_ column
CustomVariableType
bytes
null
string
long
short
integer
string
date
serializable

Regards
Martin

Re: var_type in the act_hi_detail table always 'string'

frederikherema1 — Fri, 13 Dec 2013 07:53:39 GMT

Can you show us HOW you add the variables to the process (java-code)?

Re: var_type in the act_hi_detail table always 'string'

troy_doty — Fri, 13 Dec 2013 19:09:22 GMT

OK, yup. It was how we were storing them. Like I mentioned, I am new to this. 😃

Looks like we take a JSON payload which is just a map of Strings to Strings. So we are storing them all as String objects which I'm assuming Activiti will store as a "string" type.

Thanks for the quick response and sorry for posting such a simple question.