Saviynt Solutions

  select  analyticskey as analyticsConfigES__primarykey, 1 as analyticsConfigES__updateuser from analyticsConfigES where analyticskey=2037 limit 1; select  analyticskey as analyticsConfigES__primarykey, replace(ANALYTICSQRY,' limit 1','') as analyticsConfigES__ANALYTICSQRY from analyticsConfigES where analyticskey=2037 limit 1;

 select ${binding.variables} as id select '${binding.variables.collect { key, value -> "$key:$value" }.join(', ')}' as id NEW REQUEST 2024-08-14T11:44:36-04:00 - ecm - - null-jdr2b - - 14-Aug-2024 15:44:35.350 WARNING [http-nio-8080-exec-114] groovy.sql.Sql$AbstractQueryCommand.execute Failed to execute: select [requestee:208657, REQUESTOR:208657, REQUESTEE:208657, user:145835, requestor:208657, out:java.io.PrintWriter@a04238e] as id because: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[requestee:208657, REQUESTOR:208657, REQUESTEE:208657, user:145835, requestor:20' at line 1 Modify service account [requestee:9061, REQUESTOR:9061, REQUESTEE:9061, user:rushikesh.vartak@dd' Role Type r.customproperty10 ='HR' and 200=200 and r.customproperty10 not in (select u.id from Users u) and r.customproperty10 not in (select ${binding.variables} as id from dual)...