topic Re: More on HistoricProcessInstanceQuery issue in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/more-on-historicprocessinstancequery-issue/m-p/24688#M12108 <HTML><HEAD></HEAD><BODY><SPAN>Paul… I see you are re-using the object instance 'piHistory' tree times. When you use "unfinished", the query instance will ALWAYS return the unfinished processes, in other words, the HistoricProcessQuery (and all queries in our API) are statefull.</SPAN><BR /><BR /><SPAN>What you want do do, should look like this:</SPAN><BR /><CODE><BR /><BR />System.out.println("Total Historic Processes = "+historyService.createHistoricProcessInstanceQuery().count());<BR />System.out.println("Processes in progress = "+historyService.createHistoricProcessInstanceQuery().unfinished().count());<BR />System.out.println("Total Historic Processes = "+historyService.createHistoricProcessInstanceQuery().count());<BR /><BR /></CODE></BODY></HTML> Fri, 10 Dec 2010 17:57:08 GMT frederikherema1 2010-12-10T17:57:08Z More on HistoricProcessInstanceQuery issue https://connect.hyland.com/t5/alfresco-archive/more-on-historicprocessinstancequery-issue/m-p/24687#M12107 It seems to be not as simple as just the finished() method not working. The results seem to depend on what was called previouslly - or I really am missing something obvious here.The code :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("Total Historic Processes = "+piHistory.count());&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println("Processes in Fri, 10 Dec 2010 16:35:43 GMT https://connect.hyland.com/t5/alfresco-archive/more-on-historicprocessinstancequery-issue/m-p/24687#M12107 pault 2010-12-10T16:35:43Z Re: More on HistoricProcessInstanceQuery issue https://connect.hyland.com/t5/alfresco-archive/more-on-historicprocessinstancequery-issue/m-p/24688#M12108 <HTML><HEAD></HEAD><BODY><SPAN>Paul… I see you are re-using the object instance 'piHistory' tree times. When you use "unfinished", the query instance will ALWAYS return the unfinished processes, in other words, the HistoricProcessQuery (and all queries in our API) are statefull.</SPAN><BR /><BR /><SPAN>What you want do do, should look like this:</SPAN><BR /><CODE><BR /><BR />System.out.println("Total Historic Processes = "+historyService.createHistoricProcessInstanceQuery().count());<BR />System.out.println("Processes in progress = "+historyService.createHistoricProcessInstanceQuery().unfinished().count());<BR />System.out.println("Total Historic Processes = "+historyService.createHistoricProcessInstanceQuery().count());<BR /><BR /></CODE></BODY></HTML> Fri, 10 Dec 2010 17:57:08 GMT https://connect.hyland.com/t5/alfresco-archive/more-on-historicprocessinstancequery-issue/m-p/24688#M12108 frederikherema1 2010-12-10T17:57:08Z