Hi 

I’m using an advanced query to return a list of process instances and their associated process variables. When I include the pagination options as part of the rest request it appears the pagination is functioning at the child process variable level and not on the parent process level as expected.

Has anyone else had a similar experience ? Is there a way of changing the items that are paginated ?

This is the query that I registered. Its the same query as jbpmProcessInstancesWithVariables which you don’t appear to be able to use for some reason:

 { "query-name" : "getProcesses",
  "query-source" : "java:jboss/datasources/jbpmDS",
  "query-expression" : "select vil.processInstanceId, vil.processId, vil.id, vil.variableId, vil.value from VariableInstanceLog vil where vil.id = (select MAX(v.id) from VariableInstanceLog v where v.variableId = vil.variableId and v.processInstanceId = vil.processInstanceId)",
  "query-target" : "CUSTOM"
  }

Add this is the rest call I make to retrieve the data:

http://localhost:8081/kie-server/services/rest/server/queries/definitions/getProcesses/filtered-data?mapper=ProcessInstancesWithVariables&page=0&pageSize=10

{
  "process-instance": [
    {
      "process-instance-id": 1,
      "process-id": "demo1.inventory",
      "process-version": "",
      "process-instance-state": -1,
      "correlation-key": "",
      "process-instance-variables": {
        "shoe_size": "12",
        "processId": "demo1.inventory",
        "initiator": "bpmsAdmin"
      }
    },
    {
      "process-instance-id": 2,
      "process-id": "demo1.SampleProcess",
      "process-version": "",
      "process-instance-state": -1,
      "correlation-key": "",
      "process-instance-variables": {
        "initiator": "bpmsAdmin",
        "outName": "testOut",
        "inName": "123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345"
      }
    }
  ]
}