ACT_HI_DETAIL variable Type Bug ?

[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
Losky

[trademak]

Hi,

Did you look in the user guide at the history configuration:

http://activiti.org/userguide/index.html#historyConfig

You have to set the level to full if you also want process variables to be stored.

In the Activiti form property api we convert the variables to the right format, but if you want to do a report based on the database that's a bit difficult.
But for process variables not only the text column is filled but the column corresponding to the type. Is that enough for you?

Best regards,

[losky]

Im very very gratefull for your answer
I didnt noticed that configuration parameter.
Doing this plus a little of work to save the process parameters of the active process will do the tric

Thanks
Pablo