Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/19/2024 04:57 AM
Hello,
I am using the SAV to filter on the Whom to Request. I am using the JSON below. With this Json i don't see any user when doing a RequestAccessforOthers - multi other then the requestor.
1-) Anyone know what how to add a block for it please? (for the RequestAccessforOthers - multi )
2-) Concerning the UpdateUserRequest, what should i correct so the requestor doesn't show up in the list also? (the filter her is working but the requestor is also present in the list and i want to exclude him)
[
{
"for": "UpdateUserRequest",
"query": "
SELECT a
FROM Users a
WHERE a.manager = ${users.id}
AND a.statuskey = 1
AND (
a.username LIKE 'EX%'
OR a.username LIKE 'CD%'
OR a.username LIKE 'SO%'
)"
},
{
"for": "RequestAccessforOthers",
"query": "
SELECT a
FROM Users a
WHERE a.username <> 'systemadmin'
AND a.username NOT LIKE 'admi%'
AND a.username NOT LIKE 'saviy%'"
}
]
Thank you in advance,
Ray
Solved! Go to Solution.
07/19/2024 05:53 AM - edited 07/19/2024 06:19 AM
RequestAccessOthersMultiUser try this
[{"for":"RequestAccessforOthers","query":"SELECT a FROM Users a WHERE a.username <> 'systemadmin' AND a.username NOT LIKE 'admi%' AND a.username NOT LIKE 'saviy%'"},{"for":"UpdateUserRequest","query":"SELECT a FROM Users a WHERE a.manager = ${users.id} AND a.statuskey = 1 AND (a.username LIKE 'EX%' OR a.username LIKE 'CD%' OR a.username LIKE 'SO%')"},{"for":"RequestAccessOthersMultiUser","query":"SELECT a FROM Users a WHERE a.username <> 'systemadmin' AND a.username NOT LIKE 'admi%' AND a.username NOT LIKE 'saviy%'"}]
07/19/2024 05:55 AM
Below syntax for reference:
[{"for":"RequestAccessforOthers,RequestAccessOthersMultiUser,UpdateUserRequest,RequestEnterpriseRoles,ViewExistingAccess","query":"select a from Users a where a.username not in ('admin','SaviyntSupportAgent1','SaviyntSupportAgent2','SaviyntSupportAgent3','systemadmin')"}]
07/19/2024 06:11 AM
Hi @ray ,
1-) Anyone know what how to add a block for it please?
[{"for":"RequestAccessforOthers","query":"SELECT a FROM Users a WHERE a.username <> 'systemadmin' AND a.username NOT LIKE 'admi%' AND a.username NOT LIKE 'saviy%'"},{"for":"UpdateUserRequest","query":"SELECT a FROM Users a WHERE a.manager = ${users.id} AND a.statuskey = 1 AND (a.username LIKE 'EX%' OR a.username LIKE 'CD%' OR a.username LIKE 'SO%')"},{"for":"RequestAccessOthersMultiUser","query":"SELECT a FROM Users a WHERE a.username <> 'systemadmin' AND a.username NOT LIKE 'admi%' AND a.username NOT LIKE 'saviy%'"}]
2-) Concerning the UpdateUserRequest, what should i correct so the requestor doesn't show up in the list also? (the filter her is working but the requestor is also present in the list and i want to exclude him)
This is not possible. Requestor will always be seen in update user request.
If this helps, please consider selecting Accept as Solution and hit Kudos
07/19/2024 07:25 AM
Thanks, all the answers worked.
I still have one issue in the Update user Request : How to exclude the requestor from the list please?
"for":"UpdateUserRequest","query":"SELECT a FROM Users a WHERE a.manager = ${users.id} AND a.statuskey = 1 AND (a.username LIKE 'EX%' OR a.username LIKE 'CD%' OR a.username LIKE 'SO%')"}
Regards,
Ray
07/19/2024 08:00 AM
@ray ,
As mentioned above, we can't hide the requestor in update user request.
If we explicitly mention a.userkey !='${users.id}, the list will always be empty even though the users are seen when we run the query in data analyzer.
Please raise an idea on this - https://ideas.saviynt.com/
If this helps, please consider selecting Accept as Solution and hit Kudos
07/25/2024 08:10 AM
The filter is working in the updateuserrequest.
But when i select a user from the list and i click on Next, i am redirected to home page. Anyone faced this problem please ?
07/25/2024 03:37 PM
Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .
‼️‼️⚠️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.⚠️‼️‼️