2018-11-13 14:38:46 INFO  BpmAdvancedQueryNativeTest:96 - ******************* Start tasksByVariablesAndParamsWithVariablesAndParamsTest ********************
Hibernate: select distinct ti.ID, ti.ACTIVATIONTIME, ti.ACTUALOWNER, ti.CREATEDBY, ti.CREATEDON, ti.DEPLOYMENTID, ti.DESCRIPTION, ti.DUEDATE, ti.NAME, ti.PARENTID, ti.PRIORITY, ti.PROCESSID, ti.PROCESSINSTANCEID, ti.PROCESSSESSIONID, ti.STATUS, ti.TASKID, ti.WORKITEMID, tv.name tvname, tv.value tvvalue  from AuditTaskImpl ti  inner join (select tv.taskId, tv.name, tv.value from TaskVariableImpl tv where tv.type = 0) tv  on (tv.taskId = ti.taskId)  where ti.taskid in ( select task.taskid    from audittaskimpl task    inner join (          select param.taskid, param.name, param.value           from taskvariableimpl param           where param.type = 0     ) param    on (param.taskid = task.taskid)    inner join variableinstancelog variable    on (variable.processinstanceid = task.processinstanceid)    inner join (          select vil.processinstanceid ,vil.variableid, max(vil.id) maxvilid          from variableinstancelog vil          group by vil.processinstanceid, vil.variableid          order by vil.processinstanceid    ) x    on (variable.variableid = x.variableid and variable.id = x.maxvilid)    where ((status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') AND ((param.name = 'Skippable' AND param.value in ('true')))) AND ((variable.variableid = 'initiator' AND variable.value in ('bpmsAdmin')))) ) order by ti.taskId asc

Hibernate:  select pil.ID, pil.CORRELATIONKEY, pil.DURATION, pil.END_DATE, pil.EXTERNALID, pil.USER_IDENTITY, pil.OUTCOME, pil.PARENTPROCESSINSTANCEID, pil.PROCESSID, pil.PROCESSINSTANCEDESCRIPTION, pil.PROCESSINSTANCEID, pil.PROCESSNAME, pil.PROCESSVERSION, pil.START_DATE, pil.STATUS, v.variableId, v.value  from ProcessInstanceLog pil  INNER JOIN VariableInstanceLog v  ON (v.processInstanceId = pil.processInstanceId)  INNER JOIN (  	select vil.processInstanceId ,vil.variableId, MAX(vil.ID) maxvilid  	FROM VariableInstanceLog vil  	GROUP BY vil.processInstanceId, vil.variableId  	ORDER BY vil.processInstanceId  ) x  ON (v.variableId = x.variableId  AND v.id = x.maxvilid)  where pil.processInstanceId in (select ti.processInstanceId  from AuditTaskImpl ti  inner join (select tv.taskId, tv.name, tv.value from TaskVariableImpl tv where tv.type = 0) tv  on (tv.taskId = ti.taskId)  where ti.taskid in ( select task.taskid    from audittaskimpl task    inner join (          select param.taskid, param.name, param.value           from taskvariableimpl param           where param.type = 0     ) param    on (param.taskid = task.taskid)    inner join variableinstancelog variable    on (variable.processinstanceid = task.processinstanceid)    inner join (          select vil.processinstanceid ,vil.variableid, max(vil.id) maxvilid          from variableinstancelog vil          group by vil.processinstanceid, vil.variableid          order by vil.processinstanceid    ) x    on (variable.variableid = x.variableid and variable.id = x.maxvilid)    where ((status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') AND ((param.name = 'Skippable' AND param.value in ('true')))) AND ((variable.variableid = 'initiator' AND variable.value in ('bpmsAdmin')))) ) )


2018-11-13 14:39:09 INFO  BpmAdvancedQueryNativeTest:104 - ******************* tasksByVariablesAndParamsWithVariablesAndParamsTest result size: 3 ********************
2018-11-13 14:39:09 INFO  BpmAdvancedQueryNativeTest:105 - ******************* Stop  tasksByVariablesAndParamsWithVariablesAndParamsTest ********************
2018-11-13 14:39:09 INFO  DriverManagerConnectionProviderImpl:160 - HHH000030: Cleaning up connection pool [jdbc:postgresql://localhost:5432/jbpm]