Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/09/2022 08:45 PM
Hi Team,
We want to mask some set of emails , so we need to update Users table , the query worked week before but its not working now.
update users set email=concat(email,’_dev’) where city='Singapore'
Is that Job depricated aleady , any idea ?
Can you let us know how to mask bulk emails
Solved! Go to Solution.
10/09/2022 11:38 PM
Does it satisfies to any user ? Please run select query from data analyzer
select email from users where city='Singapore' and email not like '%dev';
if above query returns result then what is error in log ?
what is frequency of job ?
try adding semi colon in end
10/10/2022 05:57 AM
Yes we have results coming in Data Analyser. There is no error in the logs but query is printing.
Its adhoc job we are running on demand, tried with semi colon as well.
10/10/2022 06:03 AM
Try Below query (Your query has wrong single quote near _dev
update users set email = concat(email, ' _dev ') where city = 'Singapore'
10/10/2022 06:33 AM
Thanks it worked.