Hello everyone , I am trying to import accounts from a MSSQL server database using DB connector in Saviynt but it is failing with the below error, please suggest any changes which I can make to my account import -->"ecm-worker","2023-05-31T11:04:58...
Hello Everyone, We are trying to copy the email of the account owner into the customproperty of the same account , for the same we have written the below query which works fine in data analyzer but fails for SAV4SAV db import , meanwhile I try to fe...
Use Case:If user customproperty25 is updated through import then customproperty60 of that user should be updated as "transferred" , so I am using the User Pre-processor Config JSON during csv import as shown below and the preprocessor json I am usin...
Hello, I have the following use case-->For instance, If an entitlement(ENT_A) that has comp code(entitlement attribute) as A100, A200,A150,A050 then during the filtering process in ARS the corresponding entitlement should be visible to select on any ...
Hi All,I have written a sql query to update entitlement attributes using CTE(Common Table expression) but I am getting a syntax error in the Saviynt logs which says- "groovy.sql.Sql.withBatch Error during batch execution: You have an error in your SQ...
Tried the below query and it worked , thank you.UPDATE entitlement_values INNER JOIN(select group_concat(distinct minvalue) as minval, ENTITLEMENT_VALUE from fields left join entitlement_objectsON fields.fieldkey = entitlement_objects.field_key left ...
select group_concat(distinct minvalue), ENTITLEMENT_VALUE from fields , entitlement_objects, entitlement_values where fields.fieldkey = field_key and entitlement_objects.ENTITLEMENT_VALUEKEY = entitlement_values.ENTITLEMENT_VALUEKEY and entitlement_v...
I tried the below update query using group_concat but it is running infinitely with no ending time hence nothing could be seen in logs, and the select statement with the same query is giving me the result in the desired format, so kindly suggest any ...
I solved it with the following query -->{"ADDITIONALTABLES": {"USERS": "SELECT username,customproperty60,customproperty25 FROM USERS"},"COMPUTEDCOLUMNS": ["username","customproperty60","customproperty25"],"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA, CU...
My version is v2021, in that case custom query is working and I will try to use group_concat as suggested by you. Also the requirement is that for an Entitlement(Ent_A) we need to store (A100, A200, A300) and so on in the custompropertyxx and then di...
