topic Re: using includeProcessVariables() in historyService.createHistoricProcessInstanceQuery() in Alfresco Archive

using includeProcessVariables() in historyService.createHistoricProcessInstanceQuery()

justass — Wed, 26 Nov 2014 07:59:01 GMT

Hello, I am using historyService.createHistoricProcessInstanceQuery().includeProcessVariables()…..list() to create reports from historical process executions data. However, with more historic process executions, the createHistoricProcessInstanceQuery doesn't return not all the results. In org.act

Re: using includeProcessVariables() in historyService.createHistoricProcessInstanceQuery()

jbarrez — Fri, 05 Dec 2014 14:28:39 GMT

20 000 results is a lot - as shown in the code there, a lot is done in-memory.

What is your use case for needing so much data in one go?

Re: using includeProcessVariables() in historyService.createHistoricProcessInstanceQuery()

justass — Thu, 08 Jan 2015 15:14:32 GMT

The use case was to create simple report. There are a lot process executions (more than 20000 so far), and I needed to collect 5 string variable values from each process and show a list to user. I ended up using plain sql queries for that.

I think it would be good to mention hardcoded 20000 limitation (or let the user change the default value) in user guide. It would help the developers to avoid surprises when query stops returning expected results after some time