topic Problem with CreateTaskQuery with multiple taskVariables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-createtaskquery-with-multiple-taskvariables/m-p/170675#M123947 <HTML><HEAD></HEAD><BODY><SPAN>hi,</SPAN><BR /><BR /><SPAN>My task contains certain local variables (String)</SPAN><BR /><BR /><SPAN>Its getting stored in ACT_RU_VARIABLES table in DB.</SPAN><BR /><BR /><SPAN>e.g.</SPAN><BR /><BR /><SPAN>Name_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Text_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | task_id_</SPAN><BR /><SPAN>CustName1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 101</SPAN><BR /><SPAN>CustName2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 101</SPAN><BR /><SPAN>CustName3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 101</SPAN><BR /><SPAN>CustName1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 102</SPAN><BR /><SPAN>CustName2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 102</SPAN><BR /><BR /><BR /><SPAN>I want to retrieve the tasks based on following criteria</SPAN><BR /><SPAN>Tasks having Name_ as CustName1&nbsp; and value as CustVal1&nbsp; and&nbsp; Name_ as CustName2&nbsp; and value as CustVal2&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>I am using&nbsp; createTaskQuery but it is not retrieving tasks. I am expecting task_ids 101, 102 to be retrieved..</SPAN><BR /><BR /><SPAN>Statement in JAVA code is as below</SPAN><BR /><SPAN>List&lt;Task&gt; myTask_1 = taskService.createTaskQuery().taskVariableValueEquals("CustName1", "CustVal1").taskVariableValueEquals("CustName2", "CustVal2").list();</SPAN><BR /><BR /><BR /><SPAN>I am not able to form the native query for this which i feel would become complex.</SPAN><BR /><BR /><SPAN>Can you suggest what can be done in this case? </SPAN><BR /><SPAN>Is something wrong with the code i have written?&nbsp; why its not retrieving the tasks?</SPAN><BR /><SPAN>Please advise.</SPAN><BR /><BR /><SPAN>Omkar</SPAN><BR /></BODY></HTML> Wed, 08 Jan 2014 09:10:58 GMT omkarrege 2014-01-08T09:10:58Z Problem with CreateTaskQuery with multiple taskVariables https://connect.hyland.com/t5/alfresco-archive/problem-with-createtaskquery-with-multiple-taskvariables/m-p/170675#M123947 hi,My task contains certain local variables (String)Its getting stored in ACT_RU_VARIABLES table in DB.e.g.Name_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Text_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | task_id_CustName1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 101CustName2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 101CustName3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | CustVal3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 101CustName1&nbsp; Wed, 08 Jan 2014 09:10:58 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-createtaskquery-with-multiple-taskvariables/m-p/170675#M123947 omkarrege 2014-01-08T09:10:58Z Re: Problem with CreateTaskQuery with multiple taskVariables https://connect.hyland.com/t5/alfresco-archive/problem-with-createtaskquery-with-multiple-taskvariables/m-p/170676#M123948 <HTML><HEAD></HEAD><BODY><SPAN>This is not possible with the Query Api at this moment. What you want is actually</SPAN><BR /><BR /><SPAN>'all tasks where (name is custName1 and value is custVal1) OR (name is custName2 and value is custVal2)</SPAN><BR /><BR /><SPAN>This needs to be done with a native query, the OR bit is not yet implemented in Activiti.</SPAN></BODY></HTML> Fri, 17 Jan 2014 08:25:21 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-createtaskquery-with-multiple-taskvariables/m-p/170676#M123948 jbarrez 2014-01-17T08:25:21Z