topic HistoricTaskInstanceQuery how to? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/historictaskinstancequery-how-to/m-p/125584#M88376 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I would need to query (historyService.createHistoricTaskInstanceQuery()) for:</SPAN><BR /><SPAN>( tasks finished or started after specific date&nbsp; ) &amp;&amp; (finished after their dueDate).</SPAN><BR /><BR /><SPAN>*Questions*</SPAN><BR /><SPAN>How to build such a query? (I did not see any possibility to build it with current HistoricTaskInstanceQuery, NativeHistoricTaskInstanceQuery depends on used DB.)</SPAN><BR /><BR /><SPAN>I can extend HistoricTaskInstanceQuery, or Does anybody see other solution for querying HistoricTaskInstances?</SPAN></BODY></HTML> Thu, 31 Jan 2013 15:34:47 GMT gromar 2013-01-31T15:34:47Z HistoricTaskInstanceQuery how to? https://connect.hyland.com/t5/alfresco-archive/historictaskinstancequery-how-to/m-p/125584#M88376 Hello,I would need to query (historyService.createHistoricTaskInstanceQuery()) for<IMG id="smileysad" class="emoticon emoticon-smileysad" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /> tasks finished or started after specific date&nbsp; ) &amp;&amp; (finished after their dueDate).*Questions*How to build such a query? (I did not see any possibility to build it with current HistoricTaskInstanceQuery, Nat Thu, 31 Jan 2013 15:34:47 GMT https://connect.hyland.com/t5/alfresco-archive/historictaskinstancequery-how-to/m-p/125584#M88376 gromar 2013-01-31T15:34:47Z Re: HistoricTaskInstanceQuery how to? https://connect.hyland.com/t5/alfresco-archive/historictaskinstancequery-how-to/m-p/125585#M88377 <HTML><HEAD></HEAD><BODY><SPAN>NativeHistoricTaskInstanceQuery -&gt; This is the way to go, if you don't want to build a custom activiti-engine.jar. See what SQL the normal HistricTaskInstanceQuery produces (if used as close as possible to your use case) and alter accordingly.</SPAN><BR /><BR /><SPAN>If you don't want to use a full custom SQL, you can alter the HistoricTaskInstanceQuery and *Impl and add all new properties you introduce to the HistoricTaskInstance.xml mapping file. There will be a "select***byQueryCriteria", this is where you should use the new introduced properties of the query to add additional fragments of SQL to the where-clause…</SPAN></BODY></HTML> Fri, 01 Feb 2013 07:49:20 GMT https://connect.hyland.com/t5/alfresco-archive/historictaskinstancequery-how-to/m-p/125585#M88377 frederikherema1 2013-02-01T07:49:20Z