topic Insert Variables per SQL in ACT_RU_VARIABLE in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176529#M129659 <HTML><HEAD></HEAD><BODY><SPAN>We had to change the handling of the tasks in our application.</SPAN><BR /><SPAN>Now i have old tasks which don't have a certain variable in the execution and would therefore be lost for the current assignee.</SPAN><BR /><BR /><SPAN>i wonder now if i can add variables in the exectution when i just add them per SQL in ACT_RU_VARIABLE like:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />INSERT INTO ACT_RU_VARIABLE (ID_, REV_,TYPE_, NAME_,EXECUTION_ID_, PROC_INST_ID_, TEXT_) VALUES ('1','1','string', 'varName', 1234, 1234, 'varValue') <BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>The values for EXECUTION_ID_ and PROC_INST_ID_ are not the problem. I can take them from ACT_RU_TASK.</SPAN><BR /><SPAN>But what is whit the ID_?</SPAN><BR /><SPAN>Can i just use MAX(ID_) +1? or will this mess up other processes?</SPAN><BR /><BR /><SPAN>thx</SPAN><BR /><SPAN>cyr</SPAN></BODY></HTML> Wed, 17 Sep 2014 08:28:03 GMT cyr1 2014-09-17T08:28:03Z Insert Variables per SQL in ACT_RU_VARIABLE https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176529#M129659 We had to change the handling of the tasks in our application.Now i have old tasks which don't have a certain variable in the execution and would therefore be lost for the current assignee.i wonder now if i can add variables in the exectution when i just add them per SQL in ACT_RU_VARIABLE like:INSE Wed, 17 Sep 2014 08:28:03 GMT https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176529#M129659 cyr1 2014-09-17T08:28:03Z Re: Insert Variables per SQL in ACT_RU_VARIABLE https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176530#M129660 <HTML><HEAD></HEAD><BODY><SPAN>No this will mess up other processes. Activiti uses a class called DbIdGenerator that generates these ids (they are strings, too!)</SPAN><BR /><BR /><SPAN>What you also could do, is create VariableInstanceEntity objects yourself, and save them using a custom Activiti command. That way, it will properly use the id generation.</SPAN></BODY></HTML> Wed, 17 Sep 2014 11:12:48 GMT https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176530#M129660 jbarrez 2014-09-17T11:12:48Z Re: Insert Variables per SQL in ACT_RU_VARIABLE https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176531#M129661 <HTML><HEAD></HEAD><BODY><SPAN>thx for your answer. tought it wouldn't be a simple SQL Query <span class="lia-unicode-emoji" title=":winking_face:">😉</span></SPAN></BODY></HTML> Wed, 17 Sep 2014 11:17:03 GMT https://connect.hyland.com/t5/alfresco-archive/insert-variables-per-sql-in-act-ru-variable/m-p/176531#M129661 cyr1 2014-09-17T11:17:03Z