Case insensitive version of $components.CheckFieldUniqueness?

Adrian Corston 2 years ago in UNIFYBroker/Plus updated 2 years ago 3

$components.CheckFieldUniqueness appears to be case sensitive, but UserPrincipalName in AD is case insensitive.

In my solution I am doing a check to ensure my UserPrincipalName field value is unique and $components.CheckFieldUniqueness tells me it is, but my update to AD fails because there that value is already present with different case.

i.e. "tom@contoso.com" vs "Tom@contoso.com"

How can I perform a case insensitive unique value check?

Satisfaction mark by Adrian Corston 2 years ago

I have tried updating the solution to use lowercase values only, by adding an adapter field with the imported UPN value converted to lower case for use in the uniqueness check code.

However at this stage I haven't been able to confirm whether or not this work because of the issue outlined in https://voice.unifysolutions.net/en/communities/6/topics/4187-generating-unique-field-values-in-link-pre-provisioning-tasks.  I will update with more information after that one is investigated.

The lowercased adapter field approach is now working for me.