topic Quering Ad-Hoc tasks with particular task and process params in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/quering-ad-hoc-tasks-with-particular-task-and-process-params/m-p/234355#M187485 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>we see the following unexpected behaviour quering an Ad-Hoc Task with an or() query including particular task query params and process query params.</SPAN><BR /><BR /><SPAN>If we perform a TaskQuery or a HistoricTaskInstanceQuery for an Ad-Hoc Task with an or() including e.g. taskId() and processDefinitionKey() in the or() part, the Ad-Hoc task is not in the result list.</SPAN><BR /><BR /><SPAN>This seemed to be caused by the inner join, configured in the corresponding mapping in /org/activiti/db/mapping/entity/Task.xml and HistoricTaskInstance.xml&nbsp; </SPAN><BR /><SPAN>If we replace this with a left outer join, the query seems to be work as exepcted.</SPAN><BR /><BR /><SPAN>Is it a bug and if yes, would it help, if we contribute a bug ticket ?</SPAN><BR /><BR /><SPAN>Unit Test is attached:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />@Rule<BR />public ActivitiRule activitiRule = new ActivitiRule();<BR />&nbsp;&nbsp;&nbsp;<BR />@Test<BR />@Deployment(resources = {"org/activiti/test/my-process.bpmn20.xml"})<BR />public void test() {<BR />&nbsp;&nbsp;&nbsp;TaskService taskService = activitiRule.getTaskService(); <BR />&nbsp;&nbsp;&nbsp;Task task = taskService.newTask();<BR />&nbsp;&nbsp;&nbsp;taskService.saveTask(task);<BR />&nbsp;&nbsp;&nbsp;List&lt;Task&gt; tasks = taskService.createTaskQuery().or().taskId(task.getId()).processDefinitionKey("xyz").endOr().list();<BR />&nbsp;&nbsp;&nbsp;assertTrue(!tasks.isEmpty());<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></CODE></PRE></BODY></HTML> Tue, 19 Jan 2016 13:11:30 GMT jonas_h 2016-01-19T13:11:30Z Quering Ad-Hoc tasks with particular task and process params https://connect.hyland.com/t5/alfresco-archive/quering-ad-hoc-tasks-with-particular-task-and-process-params/m-p/234355#M187485 Hi All,we see the following unexpected behaviour quering an Ad-Hoc Task with an or() query including particular task query params and process query params.If we perform a TaskQuery or a HistoricTaskInstanceQuery for an Ad-Hoc Task with an or() including e.g. taskId() and processDefinitionKey() in th Tue, 19 Jan 2016 13:11:30 GMT https://connect.hyland.com/t5/alfresco-archive/quering-ad-hoc-tasks-with-particular-task-and-process-params/m-p/234355#M187485 jonas_h 2016-01-19T13:11:30Z Re: Quering Ad-Hoc tasks with particular task and process params https://connect.hyland.com/t5/alfresco-archive/quering-ad-hoc-tasks-with-particular-task-and-process-params/m-p/234356#M187486 <HTML><HEAD></HEAD><BODY><SPAN>It looks like a bug, yes. Afaics, that query should return the result. </SPAN></BODY></HTML> Thu, 21 Jan 2016 08:28:27 GMT https://connect.hyland.com/t5/alfresco-archive/quering-ad-hoc-tasks-with-particular-task-and-process-params/m-p/234356#M187486 jbarrez 2016-01-21T08:28:27Z