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

Storing Multiple Comma-Separated Values in Saviynt Custom Properties

Sanjeevini
New Contributor III
New Contributor III

Hi Team,

Is it possible to store multiple comma-separated values within the same Custom Property in Saviynt using an inline preprocessor?

For instance, if CP1 currently contains the value 'ABC' and a user is updated from the source with a different value 'DEF', the preprocessor query should append the newly received value (ABC,DEF).

Is there a way to achieve this?

Thanks

5 REPLIES 5

Dhruv_Sharma
Saviynt Employee
Saviynt Employee

Hi @Sanjeevini 

We are looking into this and keep you posted.

Regards,

Dhruv Sharma

Hi @Sanjeevini 

Please let us know the source you are using for user import.

Pre-processor can be used with an additional custom property like if cp20 has old value, cp21 is coming from the import then we can use concat to store it in 3rd attribute cp22. 

Regards

Sanjeevini
New Contributor III
New Contributor III

Hi @Dhruv

We are using DB as trusted source.

@Sanjeevini : If are expecting update from import then Yes you can achieve this using inline preprocessor. Basically you have to validate if CP1 is null or not on current user state before assigning the new value. if it is null simply assign new value otherwise concatenate current value with new value

Example query:

"UPDATE NEWUSERDATA NU LEFT JOIN CURRENTUSERS CU ON NU.USERNAME = CU.USERNAME SET NU.CUSTOMPROPERTY21 = CASE WHEN CU.CUSTOMPROPERTY21 IS NOT NULL THEN CONCAT (CU.CUSTOMPROPERTY21,',',NU.CUSTOMPROPERTY21 ) ELSE NU.CUSTOMPROPERTY21 END"


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Sanjeevini
New Contributor III
New Contributor III

Thank you for the response!!