This customer is using the dashboard report when they want to filter out by date there is no result however in the server.log file shows an issue.
I've reproduced this on my side with the customer dashboard reproducer and I found the same behavior. The error we found is:
 
~~~
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date ASC LIMIT 1
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date ASC LIMIT 1
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date DESC LIMIT 1
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date DESC LIMIT 1
2023-02-28 17:42:12,528 ERROR [org.kie.server.remote.rest.jbpm.QueryDataResource] (default task-14) The request could not be understood by the server due to malformed syntax: Group 'end_date' by the given date interval type is not supported: MILLISECOND: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: 4447518e-ea5c-4109-873a-42dfae1054dc
-
-
-
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date ASC LIMIT 1
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date ASC LIMIT 1
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.SQLDataSetProvider] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date DESC LIMIT 1
2023-02-28 17:42:12,527 DEBUG [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-14) SELECT end_date FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2023-01-27' AND end_date IS NOT NULL ORDER BY end_date DESC LIMIT 1
2023-02-28 17:42:12,528 ERROR [org.kie.server.remote.rest.jbpm.QueryDataResource] (default task-14) The request could not be understood by the server due to malformed syntax: Group 'end_date' by the given date interval type is not supported: MILLISECOND: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: 4447518e-ea5c-4109-873a-42dfae1054dc
~~~