Can you help on below Customquery to Enhanced query

[NardnraP]

Hi All,

Please provide below one to Enhanced query

update accounts set NAME = concat(Name,'-Removed',' ','on-',CURRENT_TIMESTAMP) ,REFERENCED_ACCOUNTKEY = null, STATUS = 'SUSPENDED FROM IMPORT SERVICE' where SYSTEMID IN (39) and STATUS in ('Manually Suspended','2','Inactive') and NAME not like '%Removed on%';

[Raghu · Accepted solution]

@NardnraP  try below

Sample :

select concat(a.name,'-Removed',' ','on-',CURRENT_TIMESTAMP) as accounts__name,'SUSPENDED FROM IMPORT SERVICE' as accounts__status,a.accountkey as accounts__primarykey from accounts a where a.SYSTEMID IN (5) and a.STATUS in ('Manually Suspended','2','Inactive') and NAME not like '%Removed on%';

Note : systemid you can change as per application

[rushikeshvartak]

Select accountkey as accounts__primarykey,concat(name,'-Removed',' ','on-',CURRENT_TIMESTAMP) as accounts__name,'SUSPENDED FROM IMPORT SERVICE' as accounts__status,

null as accounts__REFERENCED_ACCOUNTKEY

from accounts where SYSTEMID IN (39) and STATUS in ('Manually Suspended','2','Inactive') and NAME not like '%Removed on%';

since you are on v24.2 setting null will not work. This has been fixed in v24.5

https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v24x/Release-Notes-24-5.htm#top