Column description of ACT_HI_TASKINST

BPMN & Modeling Discussion & Questions
1

Hi
How can I value the description column of ACT_HI_TASKINST table?
Is this column filled by setting the documentation field for userTasks in BPMN?

2

Hi @rezza72 ,

Yes, task’s description holds the value supplied to documentation property.
This value can be set dynamically using expression.

image
image987Ă—374 20 KB

2 Likes
3

@hassang
Thank you for the answer.
How can I change that value, when I set that dynamically?
I mean, from where can I change that?

4

Hi @rezza72,

If you mean to change it after task gets created then the only way is to update it using the task’s method setDescription.

For example: This can be done from within task listener in which you have a reference to the DelegateTask object.

1 Like
5

Hi again :))
I followed your guidelines and the value of the dynamic variable changed correctly in the camunda demo application.
But, I used the description column in the other service and I couldn’t see the changes.
Actually, it seems the variable doesn’t change.
How can I check this?

6

Hi @rezza72,

Can you please elaborate more…
Do you mean the value in the database is different from the one appears on Camunda web apps.

Can you please share your code and snips illustrated your issue.

7

@hassang
Yes exactly.
Please have a look:
This is the camunda web app:

2
2963Ă—562 39.6 KB

and I can see what I expect.

and this is the description column for the Camunda’s database which I set that through my app:
1

As you can see, the description column has null values which cause me to see null values in my application when I use this column.

and this is my bpmn:
testModel.bpmn (11.4 KB)

8

I checked the ACT_HI_TASKINST table through h2 which is for the Camunda itself.
And the description column also has null values.

2
21101Ă—449 22 KB

9

Hi @rezza72,

_Description column has the value of an empty string. (It is not NULL)

I see that you are initializing reviewStatus variable to an empty string once the process gets started.

image
image1392Ă—641 39.2 KB

If reviewStatus value gets updated after the task gets created then definitely the description’s value wouldn’t get updated as the expression ${reviewStatus} gets evaluated only on the task’s creation