topic Limitation on query tasks with variables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/limitation-on-query-tasks-with-variables/m-p/205741#M158871 <HTML><HEAD></HEAD><BODY><SPAN>There is a limitation of 20000 for query tasks with variables in org.activiti.engine.impl.persistence.entity.TaskEntityManager</SPAN><BR /><BR /><SPAN> // setting max results, limit to 20000 results for performance reasons</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; taskQuery.setMaxResults(20000);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; taskQuery.setFirstResult(0);</SPAN><BR /><BR /><SPAN>But, we need to query more that 20000 variables.. So, we have to override this class to be able to do our search, which is annoying</SPAN><BR /><BR /><SPAN>Isn't it better to implement this in the way which is configurable? So, user can choose the limitation by themselves. </SPAN><BR /><BR /></BODY></HTML> Fri, 21 Aug 2015 14:28:59 GMT tonychou 2015-08-21T14:28:59Z Limitation on query tasks with variables https://connect.hyland.com/t5/alfresco-archive/limitation-on-query-tasks-with-variables/m-p/205741#M158871 There is a limitation of 20000 for query tasks with variables in org.activiti.engine.impl.persistence.entity.TaskEntityManager // setting max results, limit to 20000 results for performance reasons&nbsp;&nbsp;&nbsp; taskQuery.setMaxResults(20000);&nbsp;&nbsp;&nbsp; taskQuery.setFirstResult(0);But, we need to query more that 2000 Fri, 21 Aug 2015 14:28:59 GMT https://connect.hyland.com/t5/alfresco-archive/limitation-on-query-tasks-with-variables/m-p/205741#M158871 tonychou 2015-08-21T14:28:59Z Re: Limitation on query tasks with variables https://connect.hyland.com/t5/alfresco-archive/limitation-on-query-tasks-with-variables/m-p/205742#M158872 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>It's true that having it configurable it's more flexible for the developers using it.</SPAN><BR /><SPAN>(We'll be happy if you could create a PR for it.)</SPAN><BR /><BR /><SPAN>Out of curiosity, why do you need to have so many results, what you would like to do with these results?</SPAN><BR /><SPAN>Usually I prefer to add some more restrictions on the query in order to have a smaller number of results (a more relevant set). </SPAN><BR /><SPAN>(I guess you are keeping one eye on the performance statistics when you are working with so many results from a single query)</SPAN></BODY></HTML> Mon, 24 Aug 2015 08:21:21 GMT https://connect.hyland.com/t5/alfresco-archive/limitation-on-query-tasks-with-variables/m-p/205742#M158872 vasile_dirla 2015-08-24T08:21:21Z