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

Unable to use UPDATE statement for Job type "Enhanced Query Execution"

JohnDoe
Regular Contributor
Regular Contributor

I am trying to create a mechanism to automatically make the Role status Inactive over a period of time by following these steps:
① Add "-old" to the end of the Role Name of the Role with "FY 2311" in the Role Description.
② Make the status of the Role with "-old" in the Role Name Inactive.

In v23.1, Execute Extension Queries (QUSTOMQUERYJOB) were used for the above procedure, each updating a Role with the following query:
① update roles set role_name = concat (role_name, '-old') where role_description like '%-old%'
② update roles set status = 0 where role_name in ('-old')

However, in production, the version was changed to v23.8 and this Job type does not exist.
Instead, there is a Job type "Enhanced Query Execution," but you cannot use the above query because you can only use SELECT statements.

How can you do this in v 23.8?

1 REPLY 1

rushikeshvartak
All-Star
All-Star

SELECT CONCAT(ROLE_NAME, '-OLD') AS ROLES__ROLE_NAME,ROLEKEY AS ROLES__PRIMARYKEY FROM ROLES R WHERE R.ROLE_DESCRIPTION LIKE '%-OLD%'

 

SELECT 0 AS ROLES__STATUS,ROLEKEY AS ROLES__PRIMARYKEY FROM ROLES R WHERE R.ROLE_NAME LIKE '%-OLD%'

 


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