AnsweredAssumed Answered

ACT_HI_DETAIL variable Type Bug ?

Question asked by losky on Jul 11, 2012
Latest reply on Jul 12, 2012 by losky
Hello everyone

Im using activiti to track some long timed burocratic process in a company
At this moment im creating a query to view historic finished process

i`ve noticed that all historical values of process are in the table ACT_HI_DETAIL
first bug (?)- i had espected that there shoud be FormVatiables and ProcessVariable, but there are only FormVariables
second bug - all the variables are recorded in the "text_" column, and for some values this is bad because dates are not in the long format and real values aren't in the double_ column, so now i have variables that should be equal in diferent formats
for examble my locale puts "9000" as "9.000", so if i sum them they are 9009 and not 18000

This was a known problem ?

off course in the ACT_RU_VARIABLE the variables are well stored, but there is nothing there of finished process
is there a workaround ? im searching in the wrong tables for my report

Thanks in advance