How to get sorted task list directly from database?

Camunda 7 Topics Discussion & Questions
1

I’m interested to get process task list directly from database using native sql sorted by process flow execution order.
Is there any specific attribute in database table which defines in which order tasks shall be executed?

Thanks!
Erki

2

Hi Erki,

please describe your use case more in detail.

What do you mean with “sorted by process flow execution order”?
Why do you want to get the task via native SQL?

Best regards,
Philipp

3

I need to show a list of planned tasks in process sorted by process flow order. It gives an overview which task is started, completed and which is next coming task.

I did not find any solution to read it out directly from database. My solution is to parse BPMN schema when it is deployed to Camunda and read out the tasks and flow order.

With best,
Erki

4

Hi Erki,

you can’t get the information directly from the database. Your solution is the right way :thumbsup:

Best regards,
Philipp