Hi,
I am investigating how the duplicate detection rules are working in CRM for an assignment, so far i understand the below points and need help in understanding additional details.
1. Everytime when you create a duplicate detection rule a record is created in duplicaterule entity.It Contains the details of Base entity,matching entity and matchcodetable etc.
2. The details of the attribues on which the rule was made are stored in duplicaterulecondition, so it may contain multiple record for each rule storing the attribue details and the condition.
3. The matchcodetable contains the matchcodes for each of the entity record using the above duplicate rule.
So far everything is fine for me, but i didnt understand how the order of the fields are used to generate matchcodes.
For example: i have created a rule saying firstname and lastname exact match.
For the record,
Firstname : jeevan
lastname: balija
middlename: kumar
city: hyd
it created a matchcode as "balija[sep]jeevan"
Then i modified it to add middlename also at the end of the rule, it updated the matchcode as
"kumar[sep]jeevan[sep]balija"
added one more field city to the rule, then it updated the matchcode as
"kumar[sep]jeevan[sep]balija[sep]hyd"
So it is difficult to understand how the order of the fields are used.
I am trying to use this built in matchcode logic for our custom import project to avoid duplicates.
Any ideas,please post a comment.