User Update Rule || Advance query

[Manu269]

Hello folks, 

We are looking for an assistance where we need to put advance rule for user update rule.

Req:

We are looking for an assistance where we need to identify all the users , username starts with V SERIES which are active but their manager is inactive.

Hence we want to trigger transfer ownership to assign to managers manager.

Assist please 

[naveenss]

Hi @Manu269 can you please try the below query?

a.username LIKE 'V-%' AND a.statuskey=1 AND a.manager in (select id from Users u where u.id=a.manager AND u.statuskey=0)

[Manu269]

Hi @naveenss already tried that it's not working.

For my case the situation is to transfer ownership - Replace user in manager when I find any v series user manager is inactive and replace it with present managers manager

[NM]

Hi @Manu269 , what error do you see?

[Manu269]

@NM while doing the preview I do see the v series user is getting returned anyhow on updating the manager status to inactive for that v series user the update history does not show the execution.

[NM]

Hi @Manu269 , i believe technically there is no update happening on user profile so it won't trigger the rule.

You can se detective rule job..(obviously we can't filter specific user update rule) as per knowledge we are on 24.2

2) via enhanced query or sav4sav update the user customproperty which will trigger the rule and after evaluating all condition ownership will be transferred .

[Manu269]

The point here is it is bringing in preview mode but not when the operation is actually performed 

[rushikeshvartak]

• Please share screenshot of configs and logs which clicked on preview

[NM]

It will show the records in preview as in the existing one but it won't trigger as there is no update.

It shows the record if we want to use detective rule job.

[Manu269]

Hello ,

Here is the solution 

a.username in ( select m.username from Users m,  Users u where m.id=u.manager and username like 'V-%' and u statuskey =1) and (a.statuskey=0) and (##a.statuskey isupdated ##)

[NM]

Hi @Manu269 , i believe from the above query you are relying on users statuskey to be updated to 0 right?

[Manu269]

Yes...

[Manu269]

Going ahead,

Team we see very limited attributes are exposed for email templates.

Can someone confirm is there a way to consolidate the list of reported users that can be sent to new manager?

[rushikeshvartak]

What attribute do you need ?

[Manu269]

We are looking to find new owner details along with the list of reportee details in single consolidated email for each manager.