Implementation of fetching all task groups

Camunda 7 Topics Discussion & Questions
1

Hello again,
I’m trying to understand how Camunda is fetching all task groups. There is no column like group_ids or similar in ACT_RU_TASK. Is the engine using process definition which is saved as blob?

Thanks!

2

Hi @dikey94,

do you mean candidate groups?

Cheers,
Tassilo

3

Hi @tasso94,
Let’s say I’m going to write my own custom query: select all tasks where candidate_group in [HR, IT].

I know I can use TaskService, this is just an example.

Thanks.

4

I’ve missed ACT_RU_IDENTITYLINK. Sorry for the mess.

Cheers.

5

Hi @dikey94,

the sql query could look like this:

select distinct * from ACT_RU_TASK RES 
  inner join ACT_RU_IDENTITYLINK I 
  on I.TASK_ID_ = RES.ID_ 
WHERE RES.ASSIGNEE_ is null 
  and I.TYPE_ = 'candidate' 
  and I.GROUP_ID_ IN ( 'HR', 'IT' );

Cheers,
Tassilo

Edit: Sorry, I was too slow. :slight_smile:

1 Like
6

@tasso94 thanks! :slight_smile: