Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
2 years, 4 months ago
I was performing some data masking on a few fields in the Account object and saw that about 150 records could not be masked due to duplicate values in a field that had an index and was marked as an external. How is that possible? I did not mask that field and that data is like that in production. Is there any way Salesforce would allow records to be indexed/marked as external to have duplicate values?
Jan 29, 2021 at 14:00
501 6 6 silver badges 19 19 bronze badges
Fields marked as an external id don't need to always be unique. Uniqueness is a separate constraint, and it is not selected by default.
So you got records with duplicate values because some process (or perhaps more likely,
somebody) duplicated a value for that external id, and the field definition did not restrict that.
Jan 29, 2021 at 15:33
Derek F Derek F
56.1k 14 14 gold badges 47 47 silver badges 88 88 bronze badges
log in to answer this question.
Not the answer you're looking for? Browse other questions tagged
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only