topic Access to Variable ID in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/access-to-variable-id/m-p/72297#M46969 <HTML><HEAD></HEAD><BODY><SPAN>For business reasons I need to extend the database for variables with attributes for a tenant-number and a display-name which are set for the variables at process instance start.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>I declared a new table in the database with a foreign key to the ACT_RU_VARIABLE.ID.</SPAN><BR /><BR /><SPAN>I start the process instances which my own subclass of StartProcessInstanceCmd.</SPAN><BR /><BR /><SPAN>In this class I can't access the variable-id, because VariableInstanceEntity is hidden in the VariableScopeImpl and not available in ExecutionEntity, which is returned from super.execute(commandContext).</SPAN><BR /><BR /><SPAN>What about adding a public getter to the Map of variableInstances in the class VariableScopeImpl?</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>public abstract class VariableScopeImpl implements Serializable, VariableScope {<BR />…&nbsp; <BR />&nbsp; public Map&lt;String, VariableInstanceEntity&gt; getVariableInstances() {<BR />&nbsp;&nbsp;&nbsp; return variableInstances;<BR />&nbsp; }<BR />}<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>With this new method I can set the VariableExtension with the foreign key to their Variables:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>public class IngoStartProcessInstanceCmd&lt;T&gt; extends StartProcessInstanceCmd&lt;T&gt; {<BR /><BR />&nbsp;&nbsp;&nbsp;public IngoStartProcessInstanceCmd(String processDefinitionKey,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String processDefinitionId, String businessKey,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;String, Object&gt; variables) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;super(processDefinitionKey, processDefinitionId, businessKey, variables);<BR />&nbsp;&nbsp;&nbsp;}<BR /><BR />&nbsp;&nbsp;&nbsp;@Override<BR />&nbsp;&nbsp;&nbsp;public ProcessInstance execute(CommandContext commandContext) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessInstance pi = null;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DeploymentCache deploymentCache = Context<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.getProcessEngineConfiguration()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.getDeploymentCache();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessDefinitionEntity processDefinition = null;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (processDefinitionId != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processDefinition = deploymentCache.findDeployedProcessDefinitionById(processDefinitionId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (processDefinition == null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw new ActivitiException("No process definition found for id = '" + processDefinitionId + "'");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} else if (processDefinitionKey != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processDefinition = deploymentCache.findDeployedLatestProcessDefinitionByKey(processDefinitionKey);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (processDefinition == null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw new ActivitiException("No process definition found for id = '" + processDefinitionId + "'");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String tenantNumber = (String) variables.get("mandant");<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Prozessvariablen anlegen<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HashMap&lt;String, Prozessvariable&gt; prozessvariablen = <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(HashMap&lt;String, Prozessvariable&gt;) processDefinition.getProperty(IngoParseListenerConstants.PROZESSVARIABLENMAPPE);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (prozessvariablen != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (Iterator&lt;String&gt; prozessvarKeys = prozessvariablen.keySet().iterator(); prozessvarKeys.hasNext();) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String prozessvarKey = (String) prozessvarKeys.next();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Prozessvariable prozessvariable = prozessvariablen.get(prozessvarKey);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.info("Prozessvariable " + prozessvariable.getKey() + " (" + prozessvariable.getDisplay() + ") " + prozessvariable.getValue());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (!variables.containsKey(prozessvariable.getKey())) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.put(prozessvariable.getKey(), prozessvariable.getValue());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pi = super.execute(commandContext);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ExecutionEntity execution = (ExecutionEntity) pi;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;String, VariableInstanceEntity&gt; variableInstances = execution.getVariableInstances();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (Iterator&lt;String&gt; variableNames = variableInstances.keySet().iterator(); variableNames.hasNext;) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String variableName = (String) variableNames.next();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Prozessvariable prozessvar = prozessvariablen.get(variableName);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (prozessvar != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String display = prozessvar.getDisplay();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (display != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String varId = variableInstances.get(variableName).getId();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VariableDisplayEntity variableDisplay = new VariableDisplayEntity(varId, display, tenantNumber);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;commandContext.getDbSqlSession().insert(variableDisplay);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (Exception e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw new ActivitiException("Error setting Execution_Extension:", e);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return pi;<BR />&nbsp;&nbsp;&nbsp;}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 20 Sep 2011 12:24:40 GMT ingo_ri 2011-09-20T12:24:40Z Access to Variable ID https://connect.hyland.com/t5/alfresco-archive/access-to-variable-id/m-p/72297#M46969 For business reasons I need to extend the database for variables with attributes for a tenant-number and a display-name which are set for the variables at process instance start. I declared a new table in the database with a foreign key to the ACT_RU_VARIABLE.ID.I start the process instances which m Tue, 20 Sep 2011 12:24:40 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-variable-id/m-p/72297#M46969 ingo_ri 2011-09-20T12:24:40Z Re: Access to Variable ID https://connect.hyland.com/t5/alfresco-archive/access-to-variable-id/m-p/72298#M46970 <HTML><HEAD></HEAD><BODY><SPAN>This was a bad idea, because changing a variable with runtimeservice.setVariables(executionId, map) do a delete and insert of a new variable with the same name:</SPAN><BR /><BR /><SPAN>…</SPAN><BR /><SPAN>13:34:50,128 FIN&nbsp; |&nbsp;&nbsp; insert VariableInstanceEntity[75]&nbsp; [org.activiti.engine.impl.db.DbSqlSession]</SPAN><BR /><SPAN>13:34:50,128 FIN&nbsp; |&nbsp;&nbsp; delete VariableInstanceEntity[58]&nbsp; [org.activiti.engine.impl.db.DbSqlSession]</SPAN><BR /><SPAN>…</SPAN><BR /><BR /><SPAN>I changed the foreign key of my new table for additional parameters of variables to execution-id and name instead of id and everything works fine without exposing the variableInstances.</SPAN></BODY></HTML> Mon, 26 Sep 2011 11:56:18 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-variable-id/m-p/72298#M46970 ingo_ri 2011-09-26T11:56:18Z