topic TaskQuery#taskVariableValueLike in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94494#M64732 <HTML><HEAD></HEAD><BODY><SPAN>I am an engineer living in Japan.</SPAN><BR /><SPAN>I am using Activiti for our application.</SPAN><BR /><BR /><SPAN>My application needs to create query using 'like' operation for task variables and process variables to find tasks.</SPAN><BR /><BR /><SPAN>Are there any solution to make 'like' query for using Activiti API?</SPAN><BR /><BR /><SPAN>I looked into API documents but I could not find good solution.</SPAN><BR /><BR /><SPAN>I try to add new interfaces. These interfaces look like,</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp; TaskQuery TaskQuery#taskVariableValueLike(String variableName, String variableValue);<BR />&nbsp;&nbsp;&nbsp; TaskQuery TaskQuery#processVariableValueLike(String variableName, String variableValue);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>And, I try to implement new interfaces.</SPAN><BR /><SPAN>Following are those code.</SPAN><BR /><BR /><SPAN>TaskQuery</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />package org.activiti.engine.task;<BR /><BR />public interface TaskQuery extends Query&lt;TaskQuery, Task&gt;{<BR />&nbsp;&nbsp;&nbsp;&nbsp; :<BR />&nbsp;&nbsp;&nbsp; TaskQuery TaskQuery#taskVariableValueLike(String variableName, String variableValue);<BR />&nbsp;&nbsp;&nbsp; TaskQuery TaskQuery#processVariableValueLike(String variableName, String variableValue);<BR />&nbsp;&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></CODE></PRE><BR /><SPAN>TaskQueryImpl</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />package org.activiti.engine.impl;<BR /><BR />public class TaskQueryImpl extends AbstractQuery&lt;TaskQuery, Task&gt; implements TaskQuery {<BR /><BR />&nbsp; :<BR /><BR />&nbsp; public TaskQuery taskVariableValueLike(String variableName, String variableValue) {<BR />&nbsp;&nbsp;&nbsp; variables.add(new TaskQueryVariableValue(variableName, variableValue, QueryOperator.LIKE, true));<BR />&nbsp;&nbsp;&nbsp; return this;<BR />&nbsp; }<BR />&nbsp; <BR />&nbsp; public TaskQuery processVariableValueLike(String variableName, String variableValue) {<BR />&nbsp;&nbsp;&nbsp; variables.add(new TaskQueryVariableValue(variableName, variableValue, QueryOperator.LIKE, false));<BR />&nbsp;&nbsp;&nbsp; return this;<BR />&nbsp; }<BR />&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></CODE></PRE><BR /><SPAN>activiti-engine/src/main/resources/org/activiti/db/mapping/entity/Task.xml</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR /><BR />&nbsp;&nbsp; :<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;foreach item="var" collection="variables" index="index"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="!var.taskVariable"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– When process instance variable is queried for, taskId should be null –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.TASK_ID_ is null<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.NAME_= #{var.name}<BR />&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; and A${index}.TYPE_ = #{var.type}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Variable value –&gt;<BR />&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; &lt;if test="var.operator.equals('EQUALS')"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.TEXT_ =&nbsp; #{var.textValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.operator.equals('LIKE')"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.TEXT_ like&nbsp; #{var.textValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.textValue2 != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.operator.equals('EQUALS')"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.TEXT2_ = #{var.textValue2}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.operator.equals('LIKE')"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.TEXT2_ like #{var.textValue2}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.longValue != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.LONG_ = #{var.longValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="var.doubleValue != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and A${index}.DOUBLE_ = #{var.doubleValue}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Null variable type –&gt;<BR />&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; and A${index}.TEXT_ is null and A${index}.TEXT2_ is null and A${index}.LONG_ is null and A${index}.DOUBLE_ is null and A${index}.BYTEARRAY_ID_ is null<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/foreach&gt;<BR /><BR />&nbsp;&nbsp;&nbsp; &lt;/where&gt;<BR />&nbsp; &lt;/sql&gt;<BR /><BR />&lt;/mapper&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>‍</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>TaskQueryTest</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />package org.activiti.engine.test.api.task;<BR />&nbsp; :<BR />public class TaskQueryTest extends PluggableActivitiTestCase {<BR />&nbsp; :<BR />&nbsp; @Deployment(resources={"org/activiti/engine/test/api/task/TaskQueryTest.testTaskVariableValueEquals.bpmn20.xml"})<BR />&nbsp; public void testTaskVariableValueLike() throws Exception {<BR />&nbsp;&nbsp;&nbsp; ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("oneTaskProcess");<BR />&nbsp;&nbsp;&nbsp; Task task = taskService.createTaskQuery().processInstanceId(processInstance.getId()).singleResult();<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // No task should be found for an unexisting var<BR />&nbsp;&nbsp;&nbsp; assertEquals(0, taskService.createTaskQuery().taskVariableValueEquals("unexistingVar", "value").count());<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Create a map with a variable for all default types<BR />&nbsp;&nbsp;&nbsp; Map&lt;String, Object&gt; variables = new HashMap&lt;String, Object&gt;();<BR />&nbsp;&nbsp;&nbsp; variables.put("longVar", 928374L);<BR />&nbsp;&nbsp;&nbsp; variables.put("shortVar", (short) 123);<BR />&nbsp;&nbsp;&nbsp; variables.put("integerVar", 1234);<BR />&nbsp;&nbsp;&nbsp; variables.put("stringVar", "stringValue");<BR />&nbsp;&nbsp;&nbsp; variables.put("booleanVar", true);<BR />&nbsp;&nbsp;&nbsp; Date date = Calendar.getInstance().getTime();<BR />&nbsp;&nbsp;&nbsp; variables.put("dateVar", date);<BR />&nbsp;&nbsp;&nbsp; variables.put("nullVar", null);<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; taskService.setVariablesLocal(task.getId(), variables);<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Test query matches<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().taskVariableValueLike("stringVar", "stringValue").count());<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().taskVariableValueLike("stringVar", "s%").count());<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().taskVariableValueLike("stringVar", "string%").count());<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().taskVariableValueLike("stringVar", "%").count());<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Test query for other values on existing variables<BR />&nbsp;&nbsp;&nbsp; assertEquals(0, taskService.createTaskQuery().taskVariableValueLike("stringVar", "999").count());<BR />&nbsp; }<BR />&nbsp; <BR />&nbsp; @Deployment(resources={"org/activiti/engine/test/api/task/TaskQueryTest.testProcessVariableValueEquals.bpmn20.xml"})<BR />&nbsp; public void testProcessVariableValueLike() throws Exception {<BR />&nbsp;&nbsp;&nbsp; Map&lt;String, Object&gt; variables = new HashMap&lt;String, Object&gt;();<BR />&nbsp;&nbsp;&nbsp; variables.put("longVar", 928374L);<BR />&nbsp;&nbsp;&nbsp; variables.put("shortVar", (short) 123);<BR />&nbsp;&nbsp;&nbsp; variables.put("integerVar", 1234);<BR />&nbsp;&nbsp;&nbsp; variables.put("stringVar", "stringValue");<BR />&nbsp;&nbsp;&nbsp; variables.put("booleanVar", true);<BR />&nbsp;&nbsp;&nbsp; Date date = Calendar.getInstance().getTime();<BR />&nbsp;&nbsp;&nbsp; variables.put("dateVar", date);<BR />&nbsp;&nbsp;&nbsp; variables.put("nullVar", null);<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Start process-instance with all types of variables<BR />&nbsp;&nbsp;&nbsp; ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("oneTaskProcess", variables);<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Test query matches<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().processVariableValueLike("stringVar", "stringValue").count());<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().processVariableValueLike("stringVar", "s%").count());<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().processVariableValueLike("stringVar", "str%").count());<BR />&nbsp;&nbsp;&nbsp; assertEquals(1, taskService.createTaskQuery().processVariableValueLike("stringVar", "string%").count());<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Test query for other values on existing variables<BR />&nbsp;&nbsp;&nbsp; assertEquals(0, taskService.createTaskQuery().taskVariableValueLike("stringVar", "999").count());<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // Test querying for task variables don't match the process-variables <BR />&nbsp;&nbsp;&nbsp; assertEquals(0, taskService.createTaskQuery().taskVariableValueLike("stringVar", "stringValue").count());<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp; }<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>‍</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> Wed, 01 Feb 2012 14:00:13 GMT tomo1 2012-02-01T14:00:13Z TaskQuery#taskVariableValueLike https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94494#M64732 I am an engineer living in Japan.I am using Activiti for our application.My application needs to create query using 'like' operation for task variables and process variables to find tasks.Are there any solution to make 'like' query for using Activiti API?I looked into API documents but I could not f Wed, 01 Feb 2012 14:00:13 GMT https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94494#M64732 tomo1 2012-02-01T14:00:13Z Re: TaskQuery#taskVariableValueLike https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94495#M64733 <HTML><HEAD></HEAD><BODY><SPAN>Can you create a Jira issue + attach your code as a patch?</SPAN></BODY></HTML> Thu, 02 Feb 2012 11:24:30 GMT https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94495#M64733 jbarrez 2012-02-02T11:24:30Z Re: TaskQuery#taskVariableValueLike https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94496#M64734 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I create an issue on Jira as ACT-1089.</SPAN><BR /><SPAN>I put API interface, implementation and test code to ACT-1089.</SPAN><BR /><SPAN>(these are my contribution.)</SPAN><BR /><BR /><SPAN>Thank you.</SPAN></BODY></HTML> Mon, 06 Feb 2012 22:52:32 GMT https://connect.hyland.com/t5/alfresco-archive/taskquery-taskvariablevaluelike/m-p/94496#M64734 tomo1 2012-02-06T22:52:32Z