topic Problem with listPage when using HistoricProcessInstanceQuery in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-listpage-when-using-historicprocessinstancequery/m-p/152142#M106818 <HTML><HEAD></HEAD><BODY><SPAN>Hi, this is my first post in this forum.</SPAN><BR /><BR /><SPAN>I have this code :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;String&gt; estados = new ArrayList&lt;String&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; estados.add("Status 1");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; estados.add("Status 2"); // etc<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;String&gt; list = new ArrayList&lt;String&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricProcessInstanceQuery hQuery = historyService.createHistoricProcessInstanceQuery().processDefinitionKey("process_pool1");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(hQuery != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(String estado : estados) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;HistoricProcessInstance&gt; hProcess = hQuery.finished()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.includeProcessVariables()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.variableValueEquals("estado", estado).list();//.listPage(offset, limit);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(hProcess != null &amp;&amp; hProcess.size() &gt; 0) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(HistoricProcessInstance hInst : hProcess) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//System.out.println((String)hInst.getProcessVariables().get("variable"));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;list.add((String)hInst.getProcessVariables().get("variable"));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Reinstante it or it won't work…<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hQuery = historyService.createHistoricProcessInstanceQuery().processDefinitionKey("process_pool1");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>The problem is in the next line</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />.variableValueEquals("estado", estado).list();//.listPage(offset, limit);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I have two finished tasks with the status "Status 1". </SPAN><BR /><BR /><SPAN>If I try </SPAN><PRE class="language-none line-numbers"><CODE>listPage(0, 10)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> it returns nothing. </SPAN><BR /><SPAN>If I try </SPAN><PRE class="language-none line-numbers"><CODE>listPage(10, 10)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> it returns nothing.</SPAN><BR /><SPAN>if I try </SPAN><PRE class="language-none line-numbers"><CODE>listPage(20, 10)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> it returns one of the two records…</SPAN><BR /><BR /><SPAN>The thing is simple, there's something wrong with that method, or I don't know how to use it. If I have two records with those conditions, then the first listPage (0, 10) should return them, but it doesn't. For now I'm using list() to return them all, but I need to use it in a pagination, but it's not working. If I search in ACT_HI_VARINST for NAME_='estado' AND TEXT_='Status 1' I get the two records.</SPAN><BR /><BR /><SPAN>I'm using activiti 5.13</SPAN><BR /><BR /><SPAN>Thanks in advance. I can't post more code, this is from my work.</SPAN></BODY></HTML> Mon, 14 Apr 2014 21:15:35 GMT emartinez 2014-04-14T21:15:35Z Problem with listPage when using HistoricProcessInstanceQuery https://connect.hyland.com/t5/alfresco-archive/problem-with-listpage-when-using-historicprocessinstancequery/m-p/152142#M106818 Hi, this is my first post in this forum.I have this code :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;String&gt; estados = new ArrayList&lt;String&gt;();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; estados.add("Status 1");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; estados.add("Status 2"); // etc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;String&gt; list = new ArrayList&lt;String&gt;();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HistoricProc Mon, 14 Apr 2014 21:15:35 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-listpage-when-using-historicprocessinstancequery/m-p/152142#M106818 emartinez 2014-04-14T21:15:35Z Re: Problem with listPage when using HistoricProcessInstanceQuery https://connect.hyland.com/t5/alfresco-archive/problem-with-listpage-when-using-historicprocessinstancequery/m-p/152143#M106819 <HTML><HEAD></HEAD><BODY><SPAN>Hmm this sounds like a bug indeed. Any chance you can show it in a simplified unit test … it's hard to reproduce without the context?</SPAN></BODY></HTML> Tue, 22 Apr 2014 10:35:38 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-listpage-when-using-historicprocessinstancequery/m-p/152143#M106819 jbarrez 2014-04-22T10:35:38Z