AnsweredAssumed Answered

Access value of process variable in the database

Question asked by caiw on Aug 23, 2012
Latest reply on Aug 23, 2012 by caiw
Hi,

I'm using BIRT to create reports to show information from a couple of Activiti processes. I'd like to access the value of a process variable that is set in a script task in one of my Activiti processes, but when I look for the variable in the database table "ACT_RU_VARIABLE" the row looks like this (I removed the columns that are empty):

ID_     REV_    TYPE_   NAME_   EXECUTION_ID_   PROC_INST_ID_  BYTEARRAY_ID_  
14188   1       serializable    employmentType  14089   14089           14187

Where is the value of employmentType stored? The TEXT_ column is empty, all there is is the BYTEARRAY_ID_, but where does that ID point to? I've searched the database but haven't been able to figure out where the value is found..

Thanks,
caiw

Outcomes