Delegate Query that returns users with a specific SAV Role

[pheeb]

This query returns what is needed in Data Analyzer:

select users.userkey from users, user_savroles where users.userkey=user_savroles.userkey and users.statuskey=1 AND user_savroles.rolekey=19

But I can't get this to work when I try to use it to filter the list of users to delegate to, anyone know if this can be made to work? the basic filter on statuskey is returning invalid users. 

[stalluri]

@pheeb 

user.manager=${user.id} or user.id=${user.manager} - Parent user reporters and his/her manager.
user.manager<>user.id and user.statuskey=1 - Active users who has managers.

[rushikeshvartak]

• Do you want to update sav role configuration or you want analytics report ?
• In both cases please elaborate requirement with example

[pheeb]

The requirement is to limit the users available in the delegation area to only users with a specific SAV role. I created a query that  returned only users with a specific SAV role in the Analyzer area, but it did not work in the global configuration delegate query. It returned zero users when the query was used there. thanks

[rushikeshvartak]

Use below query which is working 

user.statuskey=1 and user.id in (select us.userkey from User_savroles us where us.rolekey=19)