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

Enhacned Query for convert Customquery to EQ

NardnraP
New Contributor
New Contributor

Hi,

please can you provide EQ query for below sql update query

update arstasks a set a.STATUS = 3,a.provisioningcomments ='No Action Required' where a.taskkey in (1231,1241,1243,1244)

2 REPLIES 2

Raghu
Valued Contributor III
Valued Contributor III

@NardnraP  try below

SELECT '3' AS ARSTASKS__STATUS,'No Action Required' AS ARSTASKS__PROVISIONINGCOMMENTS ,A.TASKKEY AS ARSTASKS__PRIMARYKEY FROM ARSTASKS A WHERE A.TASKKEY in (1231,1241,1243,1244)


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

NardnraP
New Contributor
New Contributor

Thanks @Raghu .