nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How to get the task variables data by using sql not url

junkings

Rest call GET runtime/tasks/{taskId}/variables will fetch you the task variables data.
And I have two table ACT_HI_VARINST and ACT_RU_VARIABLE.
Should I get the data from ACT_RU_VARIABLE by taskid?

But In ACT_RU_VARIABLE , the TASK_ID_ field is all NULL.

Find more posts tagged with

Comments

jim1

The TASK_ID_ field is, I believe, only set for task local variables.

junkings

I use “SELECT * FROM ACT_RU_VARIABLE variable inner join ACT_RU_TASK task on variable.PROC_INST_ID_ = task.PROC_INST_ID_ where task.ID_ = taskId” to get it

jbarrez

the task_id for variables will only be filled if the variables are set via the taskService or in a TaskListener.
The process instance id is a better way to fetch the variables, when setting through a task, the process instance id will also be set.