After resolution of JBPM-10164, the code is moving forward and the sql date query is executed, but no data is returned.
The query being executed is
SELECT TO_CHAR(start_date, 'YYYY-MM-DD HH24:MI:SS.MS') AS "START_DATE", COUNT(processname) AS "PROCESSNAME" FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2022-03-04' GROUP BY "START_DATE" ORDER BY "START_DATE" ASC

Since date filter is performes using milliseconds, not the day, the query returns no data.
The query needs to be changed,. Either by using between or by adding date funcion (or adding extra char column with the right range, which is also wrong, because it should be day and is milliseconds)