topic Problem with .createHistoricProcessInstanceQuery() in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-createhistoricprocessinstancequery/m-p/203216#M156346 <HTML><HEAD></HEAD><BODY><SPAN>I have a problem with the historic query API.</SPAN><BR /><BR /><SPAN>I've a finished instance which appears in the ACT_HI_PROCINST table with a PROC_DEF_ID_ column with the process definition key (in my example 'MYPROCESS:1:3804'),</SPAN><BR /><SPAN>and END_TIME_ column with date value of ending.</SPAN><BR /><BR /><SPAN>when I do a sql request like this :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />select count(*) from ACT_HI_PROCINST where PROC_DEF_ID_ = 'MYPROCESS:1:3804'<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>the result value is = 1</SPAN><BR /><BR /><BR /><SPAN>Now if I do it with API like this :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />long result&nbsp; = MyProcessEngine<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .getHistoryService()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createHistoricProcessInstanceQuery()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .processDefinitionKey("MYPROCESS:1:3804")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .finished()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .count();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I get result = 0</SPAN><BR /><BR /><BR /><SPAN>Same problem if I use the processId as selector :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />long result&nbsp; = MyProcessEngine<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .getHistoryService()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createHistoricProcessInstanceQuery()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .processDefinitionId("MYPROCESS")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .finished()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .count();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I get result = 0</SPAN><BR /><BR /><BR /><SPAN>But if I use the processInstanceId (3806 in my example)</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />long result&nbsp; = MyProcessEngine<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .getHistoryService()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createHistoricProcessInstanceQuery()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .processInstanceId("3806")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .finished()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .count();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I get result = 1</SPAN><BR /><BR /><BR /><SPAN>So it seems we have to use a sql native query, or perhaps there's something wrong in my example ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></BODY></HTML> Tue, 02 Dec 2014 11:16:54 GMT cnirparis 2014-12-02T11:16:54Z Problem with .createHistoricProcessInstanceQuery() https://connect.hyland.com/t5/alfresco-archive/problem-with-createhistoricprocessinstancequery/m-p/203216#M156346 I have a problem with the historic query API.I've a finished instance which appears in the ACT_HI_PROCINST table with a PROC_DEF_ID_ column with the process definition key (in my example 'MYPROCESS:1:3804'),and END_TIME_ column with date value of ending.when I do a sql request like this :select coun Tue, 02 Dec 2014 11:16:54 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-createhistoricprocessinstancequery/m-p/203216#M156346 cnirparis 2014-12-02T11:16:54Z Re: Problem with .createHistoricProcessInstanceQuery() https://connect.hyland.com/t5/alfresco-archive/problem-with-createhistoricprocessinstancequery/m-p/203217#M156347 <HTML><HEAD></HEAD><BODY><SPAN>Have you checked databse to check its real value ?</SPAN></BODY></HTML> Tue, 02 Dec 2014 20:21:25 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-createhistoricprocessinstancequery/m-p/203217#M156347 smirzai 2014-12-02T20:21:25Z