kie-server.log

15:43:52,037 DEBUG [org.kie.server.services.jbpm.QueryDataServiceBase] (default task-9) About to unmarshal queryDefinition from payload: '<org.kie.server.api.model.definition.QueryDefinition>
  <name>jbpmHumanTasksWithVariables</name>
  <source>${org.kie.server.persistence.ds}</source>
  <expression>select tvi.taskId, tvi.name, tvi.value from TaskVariableImpl tvi</expression>
  <target>CUSTOM</target>
</org.kie.server.api.model.definition.QueryDefinition>'
15:43:52,038 DEBUG [org.kie.server.services.jbpm.QueryDataServiceBase] (default task-9) Built sql query definition for jbpmHumanTasksWithVariables with content SqlQueryDefinition [name=jbpmHumanTasksWithVariables, source=${org.kie.server.persistence.ds}, target=CUSTOM, { expression=select tvi.taskId, tvi.name, tvi.value from TaskVariableImpl tvi}]
15:43:52,040 INFO  [org.jbpm.kie.services.impl.query.persistence.PersistDataSetListener] (default task-9) Data set jbpmHumanTasksWithVariables saved in db storage
15:43:52,041 INFO  [org.kie.server.services.jbpm.JbpmKieServerExtension] (default task-9) Data source expression ${org.kie.server.persistence.ds} resolved to java:jboss/datasources/ExampleDS
15:43:52,042 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-9) SELECT * FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL" LIMIT 1
15:43:52,042 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-9) SELECT * FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL" LIMIT 1
15:43:52,042 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-9) SELECT COUNT(*) FROM (SELECT * FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL") "dbSQL"


16:03:50,880 DEBUG [org.kie.server.services.jbpm.QueryDataServiceBase] (default task-103) About to perform query 'jbpmHumanTasksWithVariables' with page 0 and page size -1
16:03:50,880 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-103) SELECT * FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL" LIMIT 1
16:03:50,880 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-103) SELECT * FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL" LIMIT 1
16:03:50,881 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-103) SELECT COUNT(*) FROM (SELECT * FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL") "dbSQL"
16:03:50,882 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-103) SELECT TASKID, NAME, VALUE FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL" WHERE TASKID IN (1) ORDER BY TASKID ASC
16:03:50,882 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-103) SELECT TASKID, NAME, VALUE FROM (SELECT TVI.TASKID, TVI.NAME, TVI.VALUE FROM TASKVARIABLEIMPL TVI) "dbSQL" WHERE TASKID IN (1) ORDER BY TASKID ASC