Storing Multiple Comma-Separated Values in Saviynt Custom Properties

[Sanjeevini]

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

[Dhruv_S]

Hi @Sanjeevini 

We are looking into this and keep you posted.

Regards,

Dhruv Sharma

[Dhruv_S]

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]

Hi @Dhruv

We are using DB as trusted source.

[sk]

@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"

[Sanjeevini]

Thank you for the response!!