Get assignee who initiated the process

Hi,

I would like to get the assignee who initiated the process throughout the lifecycle of a process. I know I will have to query ACT_HI_TASKINST but please suggest me the query as I will need that.

I will pass processId and I should get the assignee.

Awaiting for a quick response.

Thanks in advance

Hi,
You can find START_USER_ID_ in ACT_HI_PROCINST.
ACT_HI_TASKINST is for task instances not process instances.
Regards

the value in START_USER_ID_ column is null…can u plz provide a way as to how I can set this value ???

Also the query to fetch the START_USER_ID_ from this table…

Awaiting for your response

Thanks in advance

Already answered this in your other post

I am querying ACT_HI_TASKINST for historic task assignee, but I realize column ‘Assignee_’ is always empty.

How can I fix that?