How to add or remove an user from list collector field.

[sinu2]

Hi Team ,

I have an requirement, I have a scheduled report, and in that a user field list collector type present.

And i have a manager field refers to user table in the sys_user_group table. If "XYZ" group has changed the manager in that record, then we need to check the removed user in the manager fiels wheather exist in the list collector scheduled report or not. if yes the user still present means we need to remove and we need to add newly added manager in the list collector field. 

Businnes rule trigger condition on group table

When ever manager changes this BR will trigger 

Scheduled report:::::::::::::::::::::::::::::::

[sinu2]

Hi,

I tried your code but it is not adding or removing users form report table list collector.

[sinu2]

Hi Vengatesh,

User fieldy(manager) is not present in auto report table it is present in groups table.

Adding/removing list collector present in auto_report table

kindly help me in this case

[sinu2]

Hi Vengatesh,

add info messages are coming inside your code but user are not adding and removing from list collector any suggestion?

[Vengateshwaran]

Hi @sinu2,

Have you written the above code on before business rule in the 'sys_user_group' table? 

[sinu2]

yes @Vengateshwaran