topic Query for task start and end dates in Activiti in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query-for-task-start-and-end-dates-in-activiti/m-p/128161#M90100 <HTML><HEAD></HEAD><BODY><SPAN>I'm looking for a solution to query completed tasks in Activiti by filtering on the completion date. Because once they're finished completed task entries are being moved into the act_hi_taskinst table by the BPMN engine i would expected the required filters to be in the HistoricTaskInstanceQuery class. However there's nothing like startedAfter/startedBefore and finishedAfter/finishedBefore methods like in the HistoricProcessInstanceQuery. The table has the start_time_ and end_time_ columns so there's no reason why this kind of query would be not possible.</SPAN><BR /><BR /><SPAN>Is there an other way to filter by these properties or currently the only way to get around this is to query the act_hi_tasks table directly bypassing the Activiti engine?</SPAN><BR /><BR /><SPAN>–</SPAN><BR /><SPAN>I have created a question for this on StackOverflow: </SPAN><A href="http://stackoverflow.com/questions/16101151/query-for-task-start-and-end-dates-in-activiti" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/16101151/query-for-task-start-and-end-dates-in-activiti</A></BODY></HTML> Fri, 19 Apr 2013 09:21:49 GMT inagy 2013-04-19T09:21:49Z Query for task start and end dates in Activiti https://connect.hyland.com/t5/alfresco-archive/query-for-task-start-and-end-dates-in-activiti/m-p/128161#M90100 I'm looking for a solution to query completed tasks in Activiti by filtering on the completion date. Because once they're finished completed task entries are being moved into the act_hi_taskinst table by the BPMN engine i would expected the required filters to be in the HistoricTaskInstanceQuery cla Fri, 19 Apr 2013 09:21:49 GMT https://connect.hyland.com/t5/alfresco-archive/query-for-task-start-and-end-dates-in-activiti/m-p/128161#M90100 inagy 2013-04-19T09:21:49Z Re: Query for task start and end dates in Activiti https://connect.hyland.com/t5/alfresco-archive/query-for-task-start-and-end-dates-in-activiti/m-p/128162#M90101 <HTML><HEAD></HEAD><BODY><SPAN>You can use the NativeQuery functionality in the RuntimeService, this doesn't force you to bypass the activiti engine and allows you to get Task-object back from a native query. This is a workaround, you can file a Jira-issue with an "improvement", requesting for the additional methods. Or even better, create a pull-request for this <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Fri, 19 Apr 2013 09:39:03 GMT https://connect.hyland.com/t5/alfresco-archive/query-for-task-start-and-end-dates-in-activiti/m-p/128162#M90101 frederikherema1 2013-04-19T09:39:03Z