Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Multiple insert statement in Enhanced Query

Ankit_Singh
New Contributor
New Contributor

I want to insert multiple rows in account owners table via enhanced query. But it is taking only 1.

Anyone have any idea of Inserting multiple rows.

7 REPLIES 7

Raghu
Valued Contributor III
Valued Contributor III

you can use 'union' for multiple insert enhanced query execution.

example :

select 'India' as accounts__customproperty1,accountkey as accounts__primarykey from accounts where accountkey=1234 union
select 'Israel' as accounts__customproperty1,accountkey as accounts__primarykey from accounts where accountkey=12345


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Ankit_Singh
New Contributor
New Contributor

Need to do it dynamically using below query.

 

select
a.accountkey AS accountowners__accountkey,
ao.accountownerkey AS accountowners__PRIMARYKEY,
u.userkey AS accountowners__OWNERUSERKEY,
1 AS accountowners__RANK ,
sysdate() AS accountowners__UPDATEDATE ,
1 AS accountowners__UPDATEUSER
from
accountowners ao, accounts a, users u where u.username = a.customproperty20
and a.displayname like '%flkbot%'

Raghu
Valued Contributor III
Valued Contributor III

it will work dynamic also, may be where cause chck once query execution time


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Account owner table dynamic insert is not supported 

https://forums.saviynt.com/t5/identity-governance/enhanced-query-execution-to-update-account-owner/m...


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Ankit_Singh
New Contributor
New Contributor

Hi @rushikeshvartak ,

How to convince customer. They want an automated process for it. A scheduled job like thing which need not manual intervention. 

Do you have any idea how to do that.

You need to do manually no alternatives. Even actionable report also supports manual intervention 

refer doc https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Raghu
Valued Contributor III
Valued Contributor III

job scheduling automation procces only , we are not doing manually hit job everytime , you can explain clearly them.


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.