Tip #897: Alternate key, duplicate data, and solutions: part 2

Alternate key

The alternate key saga did attract some attention and we received the definite say from Brandon Simons, who’s probably as close to the proverbial Dynamics 365 metal as it gets. tl;dr Alternate keys can be in an inactive state when the definition is created but the unique index is not. These pending keys can be […]

Tip #894: Alternate key, duplicate data, and solutions

Duplicate key

tl;dr If you have duplicate values present in a field, creating alternate key on that field will fail. However, when a solution that includes alternate key is imported into the deployment where duplicates are present, the import does not fail and completes with the warning indicating that alternate key was not created. Long story Not […]

Tip #690: No field level security for alternate keys

Bunch of alternate keys

There were many people taking part in this discussion but I’m just going to take all the credit for providing the summary here. Contributors can claim the free drink from me when we meet.   If you are planning to use alternate keys to access CRM data, keep in mind that the fields with field […]