Role owner campaign filters

[HarishG]

Hi,

While configuring role owner campaign, is there any way to avoid the roles which are assigned as birthrights to the users?

Thanks,

Harish

[naveenss]

Hi @HarishG  you can achieve this by setting the value of customproperty for the role as "BIRTHRIGHT" and then use advanced query during the campaign creation to exclude such roles. Use the query like below

[rushikeshvartak]

• You can follow role naming convention as BR-
• OR use roles customproperty to define birthright role.

[HarishG]

Thank you @naveenss and @rushikeshvartak ,

But, there are few roles - which are assigned as birthrights for some users. And remaining users who still need this role will request from ARS.

can we somehow manage to include the role in certification:

• with only users who request from ARS
• and avoid users who got is as BR

Thanks,

Harish

[rushikeshvartak]

• You can use source column from role_user_account table

[naveenss]

@HarishG you can use SOURCE attribute in the role_user_account table to differentiate the roles assigned as BR and role requested by the user. 

[HarishG]

Thanks @naveenss & @rushikeshvartak ,

But role_user_account table is not working in role query. we are able to use role table and roleowner table

[naveenss]

@HarishG can you share the query you are trying?

[HarishG]

Hi @naveenss ,

Query:

and rua.source in ('REQUEST')

[naveenss]

@HarishG  use below query

and r.id in (select rua.rolekey.id from Role_user_account rua where rua.source='REQUEST')

[rushikeshvartak]

and r.id in (select rua.rolekey.id from Role_user_account rua where rua.source not in ('ZERODAY'))

Different SOurce :

REQUEST

UPDATE_ROLE

ZERODAY