MariaDB [jbpm646]> select * from ProcessInstanceLog where processId="process1"; +----+----------------+----------+---------------------+-------------------+---------------+---------+-------------------------+-----------+----------------------------+-------------------+-------------+----------------+---------------------+--------+ | id | correlationKey | duration | end_date | externalId | user_identity | outcome | parentProcessInstanceId | processId | processInstanceDescription | processInstanceId | processName | processVersion | start_date | status | +----+----------------+----------+---------------------+-------------------+---------------+---------+-------------------------+-----------+----------------------------+-------------------+-------------+----------------+---------------------+--------+ | 8 | NULL | 97114 | 2018-08-01 20:52:47 | example:proc1:1.1 | bpmsAdmin | NULL | -1 | process1 | process1 | 8 | process1 | 1.0 | 2018-08-01 20:51:10 | 2 | | 9 | NULL | 69842 | 2018-08-01 20:52:50 | example:proc1:1.1 | bpmsAdmin | NULL | -1 | process1 | process1 | 9 | process1 | 1.0 | 2018-08-01 20:51:41 | 2 | | 10 | NULL | 44174 | 2018-08-01 20:52:54 | example:proc1:1.1 | bpmsAdmin | NULL | -1 | process1 | process1 | 10 | process1 | 1.0 | 2018-08-01 20:52:10 | 2 | | 11 | NULL | NULL | NULL | example:proc1:1.1 | bpmsAdmin | NULL | -1 | process1 | process1 | 11 | process1 | 1.0 | 2018-08-01 21:00:04 | 1 | +----+----------------+----------+---------------------+-------------------+---------------+---------+-------------------------+-----------+----------------------------+-------------------+-------------+----------------+---------------------+--------+ 4 rows in set (0.00 sec) MariaDB [jbpm646]> select * from VariableInstanceLog where processId="process1"; +-----+---------------------+-------------------+----------+-----------+-------------------+--------------------+------------+--------------------+ | id | log_date | externalId | oldValue | processId | processInstanceId | value | variableId | variableInstanceId | +-----+---------------------+-------------------+----------+-----------+-------------------+--------------------+------------+--------------------+ | 129 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | process1 | processId | processId | | 130 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | aaa | str1 | str1 | | 131 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | bbb | str2 | str2 | | 132 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | 111 | i1 | i1 | | 133 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | 222 | i2 | i2 | | 134 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | abcde | var2 | var2 | | 135 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | Hiroko | var1 | var1 | | 136 | 2018-08-01 20:51:10 | example:proc1:1.1 | | process1 | 8 | bpmsAdmin | initiator | initiator | | 137 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | process1 | processId | processId | | 138 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | aaaaaaaaaaaaaaaa | str1 | str1 | | 139 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | bbbbbbbbbbbbbbbbbb | str2 | str2 | | 140 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | 9 | i1 | i1 | | 141 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | 0 | i2 | i2 | | 142 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | qwert | var2 | var2 | | 143 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | asdfg | var1 | var1 | | 144 | 2018-08-01 20:51:41 | example:proc1:1.1 | | process1 | 9 | bpmsAdmin | initiator | initiator | | 145 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | process1 | processId | processId | | 146 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | pppppppppppp | str1 | str1 | | 147 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | iiiiiiiiiiiiiiiiii | str2 | str2 | | 148 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | 54 | i1 | i1 | | 149 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | 25 | i2 | i2 | | 150 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | XYZ | var2 | var2 | | 151 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | 12345abcde | var1 | var1 | | 152 | 2018-08-01 20:52:10 | example:proc1:1.1 | | process1 | 10 | bpmsAdmin | initiator | initiator | | 153 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | process1 | processId | processId | | 154 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | 11111 | str1 | str1 | | 155 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | 22222 | str2 | str2 | | 156 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | 11111 | i1 | i1 | | 157 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | 22222 | i2 | i2 | | 158 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | aaaaa | var2 | var2 | | 159 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | bbbbb | var1 | var1 | | 160 | 2018-08-01 21:00:04 | example:proc1:1.1 | | process1 | 11 | bpmsAdmin | initiator | initiator | +-----+---------------------+-------------------+----------+-----------+-------------------+--------------------+------------+--------------------+ 32 rows in set (0.00 sec) MariaDB [jbpm646]>