Access value of process variable in the database

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

mitziuro

Actually the create for ACT_RU_VARIABLE is:

<br>create table ACT_RU_VARIABLE (<br>&nbsp;&nbsp;&nbsp; ID_ nvarchar(64) not null,<br>&nbsp;&nbsp;&nbsp; REV_ int,<br>&nbsp;&nbsp;&nbsp; TYPE_ nvarchar(255) not null,<br>&nbsp;&nbsp;&nbsp; NAME_ nvarchar(255) not null,<br>&nbsp;&nbsp;&nbsp; EXECUTION_ID_ nvarchar(64),<br>&nbsp;&nbsp;&nbsp; PROC_INST_ID_ nvarchar(64),<br>&nbsp;&nbsp;&nbsp; TASK_ID_ nvarchar(64),<br>&nbsp;&nbsp;&nbsp; BYTEARRAY_ID_ nvarchar(64),<br>&nbsp;&nbsp;&nbsp; DOUBLE_ double precision,<br>&nbsp;&nbsp;&nbsp; LONG_ numeric(19,0),<br>&nbsp;&nbsp;&nbsp; TEXT_ nvarchar(4000),<br>&nbsp;&nbsp;&nbsp; TEXT2_ nvarchar(4000),<br>&nbsp;&nbsp;&nbsp; primary key (ID_)<br>);<br>

You'll have to look at LONG_ and TEXT_ columns