03/09/2023 03:00 AM
Hi,
We have a condition to apply for set up delegate functionality where we want to restrict the request raised for delegating access for users( under Parent user) who are part of user group(members or owners). We tried using the query : 'delegates.USERKEY != usergroup_users.USERKEY' which seems not to work. Could you please help with the same.
03/09/2023 08:35 AM
What is the exact condition you are looking to achieve as the delegate user query is used to filter out the users who can be set as delegates. Users who match this query will be available to be set as a delegates.
So are you looking for a condition when the users are part of a user_group they should not be allowed to be set as delegates?
03/09/2023 01:49 PM
I am looking for a query where when the users are part of a user_group they should not be allowed to delegate their access.
03/09/2023 05:12 PM
If I understand correctly, If I am trying to set up delegate for myself(Assuming as a end user I only able to set delegate for my self) then I should not be allowed if I am member of any user group, If so use below statement.
select a from Users a where a.id = ${user?.id} and (select count(*) from Usergroup_users b where b.userkey=a.id)=0
03/12/2023 12:19 PM
Hi,
The query shared seems not working. I am not part of any user group. Now, at first place I am allowed to select my name under 'Parent User' which should not be the case and under 'Delegate User' no user list is coming up.
No user group:
Parent user:
Delegate user:
03/13/2023 06:58 AM
@Kaushik1 : Delegate list is dependent on some other configurations,
1. Do you have any delegate query setup in global configuration?
Define Delegate Query
2. What is the configuration you have on Whom to Request on respective Sav Role?
3. Does the logged user has any other SAV Roles which might have conflicting configurations?
I validated on my end when user is not part of any user group he is able to successfully apply delegate
User is not part of user group
User can see himself as user in Parent User
User can see list of users in Delegate User list
User is part of User Group
User is not able to see any user in Parent User hence won't be able to setup delegate
03/19/2023 12:48 AM
Hello,
Could you please assist on the HQL query as well under 'Whom to request'?
03/20/2023 05:58 AM
@Kaushik1 : This looks like different query to original post. If original query is solved please mark it as closed by marking the solution that helped and open a new thread for this new query. So that if helps others who are in same situation. Also please provide your requirement for Whom to Request when you are opening new thread, so that I can assist you with that.
03/24/2023 08:18 AM
Hello,
We updated the query in Savrole and global configuration but still, it seems not to work.
03/24/2023 04:21 PM - edited 03/24/2023 04:21 PM
Define Delegate Query in global configuration doesn't need to be configured unless you have restrictions on whom you can set as delegate. So if you have configured it please remove it and see
03/30/2023 05:14 AM
After updating the query shared only in Global configuration, we are unable to see user under delegate user
03/30/2023 06:35 PM
@Kaushik1 : Not sure if you followed my response or not. Query i shared is supposed to be used in SAV Role not in global configuration. Don't use any query in global configuration unless you have restrictions on whom you can set as delegate.
Query I shared will work as below if you used that in SAV Role under For whom can the user can setup delegate(no query in global configuration)
If I am trying to set up delegate for myself(Assuming as a end user I only able to set delegate for my self) then it will not allow me to do so, if I am member of any user group otherwise it will allow me to setup delegate
05/02/2023 12:17 AM
Hello Saathvik,
Could you please also help us with the query on how we can restrict users present in all the user group excluding one user group say 'x'?
05/10/2023 05:38 AM
Hello,
Could you please also help us with the query on how we can restrict users present in all the user group excluding one user group say 'x'?