Click HERE to see how Saviynt Intelligence is transforming the industry. |
02/28/2024 04:59 AM
Hi,
this topic is related to this closed thread: Limit One click disable user tab results
The use case is the following: A certain group should be allowed to use the functionality for one click disable. To achieve this setup an advanced filter at "whom to request".
To mitigate any sideshows, the user only has this role assigned and a simple filter for test purpose was created.
JSON tab:
[{"for":"OneClickDisable","query":"select a from Users a"}]
The assumption is, that if the role is assigned, the user should see all users whenever he starts the "one click disable" request.
But whenever this is tested with a user, only the user is shown and no other one.
Can someone support here?
Thanks
Solved! Go to Solution.
02/28/2024 05:58 AM
Please share logs
02/28/2024 06:03 AM
Hi @Alex , Try this in query
select new map (a.id as id) from Users
Thanks,
Amit
If this answers your query, Please ACCEPT SOLUTION and give KUDOS.
02/28/2024 06:11 AM
@rushikeshvartak :
this is all I've found related to oneclickdisable:
Let me know if you have another indicator in the logs.
@Amit_Malik I've tried that and included the query in the JSON, but with the same result.
Regards,
alex
03/19/2024 12:47 AM
Is there any update on this topic? I would need to understand, if there is a bug in the product or not.
03/19/2024 09:16 PM
I am not able to filter , Please raise support ticket
03/20/2024 12:47 AM
Thanks @rushikeshvartak for the confirmation. Ticket was raised and I will update the thread about the outcome.
04/10/2024 11:43 PM
Hi @rushikeshvartak @Amit_Malik , short update on this.
The filter is working whenever you are adding "where 1=1", so the result is shown for select a from Users a where 1=1.
I also asked the support why this is needed as from SQL perspective it would be the same as no condition at all. During troubleshooting I also found another weird behavior, whenever you are writing "select" in upper letters like "SELECT" the query is also not working and throwing a framework error.
Best regards
Alex
04/11/2024 05:43 AM
Is below worked
[{"for":"OneClickDisable","query":"select a from Users a where 1=1"}]