Hello,I am trying to run this query once but the job keeps failing and I cant see any error , not sure what the issue isupdate users set username = SUBSTRING_INDEX(SUBSTRING_INDEX(username, '_', -3), '_', 1),email = SUBSTRING_INDEX(SUBSTRING_INDEX(em...
I am trying to create a custom sav role that will allow users to request on behalf of any user in the organization but only for a particular endpoint. (Role1)For other endpoints users can raise access requests only for their immediate team members.(R...
Hello, Is there an issue with "not in" sql condition ?as I tried to execute a query with it and it failed, as a test I just put "in" and it worked, if this is an issue I will have to re-write the query as the number of users for the condition t...
I ran the select before the update its working fine, the query u have used in ur reply is missing the inner query which is a crucial part,I am unable to find anything in the logs
Hello,The query is meant to update the username and email id of some guest users. I am using it in the custom query job in my testing environment.There are many users that exist with the conditions specified.Its not a sample query but the exac...
