topic HistoricProcessInstanceQueryImpl processVariableEquals in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95908#M65842 <HTML><HEAD></HEAD><BODY><SPAN>You once had (december 2011):</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />/**<BR /> * @author Tom Baeyens<BR /> * @author Falko Menge<BR /> * @author Bernd Ruecker<BR /> */<BR />public class HistoricProcessInstanceQueryImpl extends AbstractVariableQueryImpl&lt;HistoricProcessInstanceQuery, HistoricProcessInstance&gt; implements HistoricProcessInstanceQuery {<BR /><BR />…<BR /><BR />public HistoricProcessInstanceQuery processVariableEquals(String variableName, Object variableValue) {<BR />&nbsp;&nbsp;&nbsp;variables.add(new QueryVariableValue(variableName, variableValue, QueryOperator.EQUALS));<BR />&nbsp;&nbsp;&nbsp;return this;<BR />}<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></CODE></PRE><BR /><SPAN>but now it's gone:</SPAN><BR /><BR /><EM>3095 14.12.2011 13:33:48, by trademak<BR />Rollback process variable equals query for history process instances</EM><BR /><BR /><SPAN>In HistoricProcessInstance.xml you still have:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;foreach collection="variables" index="index" item="var"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and exists (<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select HD.ID_ <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ${prefix}ACT_HI_DETAIL HD <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HD.TYPE_ = 'VariableUpdate' <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.NAME_ =&nbsp; #{var.name}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.PROC_INST_ID_ = HPI.PROC_INST_ID_ and HD.TASK_ID_ is null<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.REV_ = (select max(HDM.REV_) from ${prefix}ACT_HI_DETAIL HDM where HDM.PROC_INST_ID_ = HPI.PROC_INST_ID_ and HDM.TASK_ID_ is null and HDM.VAR_TYPE_ = #{var.type} and HDM.NAME_ = #{var.name} and HDM.TYPE_ = 'VariableUpdate')<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.TIME_ = (select max(HDM.TIME_) from ${prefix}ACT_HI_DETAIL HDM where HDM.PROC_INST_ID_ = HPI.PROC_INST_ID_ and HDM.TASK_ID_ is null and HDM.VAR_TYPE_ = #{var.type} and HDM.NAME_ = #{var.name} and HDM.TYPE_ = 'VariableUpdate')<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="!var.type.equals('null')"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.VAR_TYPE_ = #{var.type}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Variable value –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.textValue != null &amp;amp;&amp;amp; var.longValue == null &amp;amp;&amp;amp; var.doubleValue == null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.TEXT_ =&nbsp; #{var.textValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.textValue2 != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.TEXT2_ = #{var.textValue2}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.longValue != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.LONG_ = #{var.longValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.doubleValue != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.DOUBLE_ = #{var.doubleValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Null variable type –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.textValue == null &amp;amp;&amp;amp; var.textValue2 == null &amp;amp;&amp;amp; var.longValue == null &amp;amp;&amp;amp; var.doubleValue == null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and HD.TEXT_ is null and HD.TEXT2_ is null and HD.LONG_ is null and HD.DOUBLE_ is null and HD.BYTEARRAY_ID_ is null<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/foreach&gt;<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></CODE></PRE><BR /><SPAN>so you've just removed the query support.</SPAN><BR /><BR /><SPAN>Is there any particular reason for removing this feature?</SPAN><BR /><SPAN>We are planning(in our application) to reactivate it(the variable search support), so we were curious if there are any problems with this kind of approach.</SPAN></BODY></HTML> Mon, 20 Aug 2012 09:39:00 GMT mitziuro 2012-08-20T09:39:00Z HistoricProcessInstanceQueryImpl processVariableEquals https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95908#M65842 You once had (december 2011):/** * @author Tom Baeyens * @author Falko Menge * @author Bernd Ruecker */public class HistoricProcessInstanceQueryImpl extends AbstractVariableQueryImpl&lt;HistoricProcessInstanceQuery, HistoricProcessInstance&gt; implements HistoricProcessInstanceQuery {…public Histori Mon, 20 Aug 2012 09:39:00 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95908#M65842 mitziuro 2012-08-20T09:39:00Z Re: HistoricProcessInstanceQueryImpl processVariableEquals https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95909#M65843 <HTML><HEAD></HEAD><BODY><SPAN>Hi mitziuro.</SPAN><BR /><BR /><SPAN>Actually that was removed because we had not real support for doing that right, because with the history we only recorded changes in the process variables, not the latest value. We changed that recently and introduced a new table for historic process variables (see </SPAN><A href="https://app.camunda.com/confluence/display/foxUserGuide/History#History-ACTHIPROCVARIABLE" rel="nofollow noopener noreferrer">https://app.camunda.com/confluence/display/foxUserGuide/History#History-ACTHIPROCVARIABLE</A><SPAN>). Now you can again do this query, but only if the process instances has ended.</SPAN><BR /><BR /><SPAN>This change hasn't made it into 5.10, so it will be available with Activiti 5.11, or you could go with the fox-engine in the latest version (</SPAN><A href="https://app.camunda.com/confluence/display/foxUserGuide/fox+engine" rel="nofollow noopener noreferrer">https://app.camunda.com/confluence/display/foxUserGuide/fox+engine</A><SPAN>), where it is contained as well.</SPAN><BR /><BR /><SPAN>Cheers</SPAN><BR /><SPAN>Bernd</SPAN></BODY></HTML> Tue, 21 Aug 2012 06:14:36 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95909#M65843 bernd_ruecker 2012-08-21T06:14:36Z Re: HistoricProcessInstanceQueryImpl processVariableEquals https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95910#M65844 <HTML><HEAD></HEAD><BODY><SPAN>Ok, thanks.</SPAN><BR /><BR /><SPAN>We've added the old code(method processVariableEquals) in our custom class &lt;extends HistoricProcessInstanceQueryImpl&gt;, until the next Activiti release is available.</SPAN></BODY></HTML> Tue, 21 Aug 2012 13:59:24 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequeryimpl-processvariableequals/m-p/95910#M65844 mitziuro 2012-08-21T13:59:24Z