Hi. I need to run a custom SQL query to get aggregated task summary depending on some specific process variables. The query will directly run upon the CAMUNDA engine core data tables and spring boot project is used to execute this. Return type of the query is also a custom object. How can I do this?
maybe this part of the docs is a good point to start your journey: Process Engine API | docs.camunda.org
Hope this helps, Ingo