How are formKeys stored?

Camunda 7 Topics Discussion & Questions
1

How are formKey’s stored, which table? and what does “initializeFormKeys()” exactly does?
For example in:

processEngine.getTaskService().createTaskQuery().initializeFormKeys().taskAssignee(assignee).list();

I am trying to better understand what is going on, such that I can optimise a custom ibatis query in which we query some camunda tables. The outcome is missing the formKey’s such that we have to retrieve them by perform another query through the TaskService. I am wandering if this could be combined in 1 query.

1 Like
2

Hi @edbras,

the formkey is part of the BPMN diagram and not distributed into any special database column. The complete XML file is stored in ACT_GE_BYTEARRAY.

The initializeFormKey() method gets the formkey from the process model in the deployment cache and adds it to the query result.

If you think about a custom ibatis query, it may be easier to create a special table to hold all query parameters and desired results. You can sychronize the table with the help of task listeners.

Or use the camunda-bpm-taskpool: https://github.com/holunda-io/camunda-bpm-taskpool

Hope this helps, Ingo

3

Thanks for the insights, I wasn’t aware of the taskpool, looks interesting.