and more in a single search tool across platforms. Read the announcement here. |
06/15/2022 10:26 PM
Hi!
Second Rule is not creating any account for user having same atttributes then first user. Dublicate user information should lead that second accountname rule is then used if account with same name exists. I have tested these both Rules separately separated with ### in Analyzer and they are working fine.
CASE
WHEN LENGTH(REPLACE(CONCAT_WS('',CONCAT_WS('',users.customproperty3, users.customproperty6),users.customproperty7),' ','') ) > 13
THEN CONCAT((SUBSTRING(REPLACE(CONCAT_WS('',CONCAT_WS('',users.customproperty3, users.customproperty6),users.customproperty7),' ',''),1,13) ),"_vt")
ELSE CONCAT((REPLACE(CONCAT_WS('',CONCAT_WS('',users.customproperty3, users.customproperty6),users.customproperty7),' ','')),"_vt")
END
###
CASE
WHEN LENGTH(REPLACE(CONCAT_WS('',CONCAT_WS('',users.customproperty3, users.customproperty6),users.customproperty7),' ','') ) > 13
THEN CONCAT((SUBSTRING(REPLACE(CONCAT_WS('',CONCAT_WS('',users.customproperty3, users.customproperty6),users.customproperty7),' ',''),1,13) ),"1_vt")
ELSE CONCAT((REPLACE(CONCAT_WS('',CONCAT_WS('',users.customproperty3, users.customproperty6),users.customproperty7),' ','')),"1_vt")
END
Best Regards,Päivi
06/15/2022 10:45 PM
version of Saviynt is Version v2021.0
06/16/2022 04:51 AM
Hi,
Are you updating this on the Connector?