topic HistoricProcessInstanceQuery interface finished() method in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23852#M11580 <HTML><HEAD></HEAD><BODY><SPAN>I dont seem to be able to get this to work, it always seems to report 0. Or maybe I'm missing something ?</SPAN><BR /><BR /><SPAN>This code :</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricProcessInstanceQuery piHistory = historyService.createHistoricProcessInstanceQuery();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("Total Historic Processes = "+piHistory.count());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("Processes in progress = "+piHistory.unfinished().count());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("Processes completed = "+piHistory.finished().count());</SPAN><BR /><BR /><SPAN>Produces this output :</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total Historic Processes = 7</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Processes in progress = 2</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Processes completed = 0</SPAN><BR /><BR /><SPAN>The database looks like this :</SPAN><BR /><BR /><SPAN>SELECT * FROM ACT_HI_PROCINST;</SPAN><BR /><SPAN>ID_&nbsp; &nbsp;&nbsp;&nbsp;PROC_INST_ID_&nbsp; &nbsp;&nbsp;&nbsp;BUSINESS_KEY_&nbsp; &nbsp;&nbsp;&nbsp;PROC_DEF_ID_&nbsp; &nbsp;&nbsp;&nbsp;START_TIME_&nbsp; &nbsp;&nbsp;&nbsp;END_TIME_&nbsp; &nbsp;&nbsp;&nbsp;DURATION_&nbsp; &nbsp;&nbsp;&nbsp;START_USER_ID_&nbsp; &nbsp;&nbsp;&nbsp;START_ACT_ID_&nbsp; &nbsp;&nbsp;&nbsp;END_ACT_ID_&nbsp; </SPAN><BR /><SPAN>3&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:06.131&nbsp;&nbsp;&nbsp;2010-12-10 10:39:12.4&nbsp;&nbsp;&nbsp;6269&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;theEnd</SPAN><BR /><SPAN>8&nbsp;&nbsp;&nbsp;8&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:12.46&nbsp;&nbsp;&nbsp;2010-12-10 10:39:24.577&nbsp;&nbsp;&nbsp;12117&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;theEnd</SPAN><BR /><SPAN>13&nbsp;&nbsp;&nbsp;13&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:18.479&nbsp;&nbsp;&nbsp;2010-12-10 10:39:24.667&nbsp;&nbsp;&nbsp;6188&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;theEnd</SPAN><BR /><SPAN>18&nbsp;&nbsp;&nbsp;18&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:24.718&nbsp;&nbsp;&nbsp;2010-12-10 10:39:36.885&nbsp;&nbsp;&nbsp;12167&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;theEnd</SPAN><BR /><SPAN>23&nbsp;&nbsp;&nbsp;23&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:30.736&nbsp;&nbsp;&nbsp;2010-12-10 10:39:36.945&nbsp;&nbsp;&nbsp;6209&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;theEnd</SPAN><BR /><SPAN>28&nbsp;&nbsp;&nbsp;28&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:36.975&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;null</SPAN><BR /><SPAN>33&nbsp;&nbsp;&nbsp;33&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;financialReport:1&nbsp;&nbsp;&nbsp;2010-12-10 10:39:43.004&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;null&nbsp;&nbsp;&nbsp;theStart&nbsp;&nbsp;&nbsp;null</SPAN><BR /><SPAN>(7 rows, 10 ms)</SPAN></BODY></HTML> Fri, 10 Dec 2010 10:54:12 GMT pault 2010-12-10T10:54:12Z HistoricProcessInstanceQuery interface finished() method https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23852#M11580 I dont seem to be able to get this to work, it always seems to report 0. Or maybe I'm missing something ?This code :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricProcessInstanceQuery piHistory = historyService.createHistoricProcessInstanceQuery();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("Total Historic Processes = "+piHistory.count());&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fri, 10 Dec 2010 10:54:12 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23852#M11580 pault 2010-12-10T10:54:12Z Re: HistoricProcessInstanceQuery interface finished() method https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23853#M11581 <HTML><HEAD></HEAD><BODY><SPAN>As I mentioned in </SPAN><A href="http://forums.activiti.org/en/viewtopic.php?f=3&amp;t=593" rel="nofollow noopener noreferrer">http://forums.activiti.org/en/viewtopic.php?f=3&amp;t=593</A><SPAN>, the Query instances in our query API are statefull (they keep the unfinished() etc. internally).</SPAN><BR /><BR /><SPAN>Ask new query-instances from the HistoryService, for each different query you want to perform. Offcourse, this doesn't mean that query instances cannot be reused.</SPAN></BODY></HTML> Fri, 10 Dec 2010 18:01:16 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23853#M11581 frederikherema1 2010-12-10T18:01:16Z Re: HistoricProcessInstanceQuery interface finished() method https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23854#M11582 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, I understand - should have realised, but it works fine now.</SPAN></BODY></HTML> Fri, 10 Dec 2010 18:28:14 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23854#M11582 pault 2010-12-10T18:28:14Z Re: HistoricProcessInstanceQuery interface finished() method https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23855#M11583 <HTML><HEAD></HEAD><BODY><SPAN>Glad to be of service. Enjoy activiti!</SPAN></BODY></HTML> Fri, 10 Dec 2010 18:38:28 GMT https://connect.hyland.com/t5/alfresco-archive/historicprocessinstancequery-interface-finished-method/m-p/23855#M11583 frederikherema1 2010-12-10T18:38:28Z