We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

CustomQueryJob in EIC version

SanketBhandhari
New Contributor
New Contributor

Hi All,

I want to use customqueryjob in EIC version of Saviynt but in my query I am getting error.

SELECT '<<AccountName>>' AS NAME FROM ACCOUNTS  where ACCOUNTKEY = <<AccountKey>>;

My requirement is to update account name of particular user using his accountkey.

Any help or pointer is much appreciated.

Regards,

Sanket Bhandhari

1 REPLY 1

SumathiSomala
All-Star
All-Star

@SanketBhandhari try below query

SELECT 'savtest99' AS ACCOUNTS__NAME ,ac.accountkey as ACCOUNTS__PRIMARYKEY FROM ACCOUNTS ac where ac.accountkey=4007;

Use Enhanced Query Execution Job

SumathiSomala_0-1701785099578.png

 

 

 

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.