Static records limit in TaskEntityManager

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

savanladani

Hi,

I don't understand why there is 20000 max records limit in TaskEntityManager while fetching task list. why we can't pass dynamic pagination value to query?

// paging doesn't work for combining task instances and variables due to an outer join, so doing it in-memory
    if (taskQuery.getFirstResult() < 0 || taskQuery.getMaxResults() <= 0) {
      return Collections.EMPTY_LIST;
    }
    
    int firstResult = taskQuery.getFirstResult();
    int maxResults = taskQuery.getMaxResults();
    
    // setting max results, limit to 20000 results for performance reasons
    taskQuery.setMaxResults(20000);
    taskQuery.setFirstResult(0);
    
    List<Task> instanceList = getDbSqlSession().selectListWithRawParameterWithoutFilter(query, taskQuery, taskQuery.getFirstResult(), taskQuery.getMaxResults());
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

jbarrez

This is for fetching variables only when doing task queries. 20K should be enough (you'll have performance issues otherwise).

But you are right, it should be configurable.