Duplicate detection rules not making sense

(0) Share

Report

Posted on by Daniel at VNS

We have an entity for Servers with a mandatory field for serial numbers. Sometimes people enter a . (dot) in there as a placeholder until they get the number. This was generating a lot of dup detection false positives since it was set for exact match. So i changed it to exact match + first 3 characters must match. I've read that these criteria are considered an AND statement by CRM.

So logically I would assume that two .'s (dots) would NOT be a dup match because they aren't 3 characters long. ... (3 dots) would be a match but not 1 - right?

So can anyone explain why this criteria is still not preventing a dup detection alert when two records are saved where serial number = . (dot)? Thank you.

*This post is locked for comments

All responses (4)

Answers (1)

Daniel at VNS on at

Like (1)

Report

RE: Duplicate detection rules not making sense

Thank you again Prashant.
Verified answer

PS 23,577 on at

Like (1)

Report

RE: Duplicate detection rules not making sense

Hi Daniel,

In this case, system will consider the first condition which is 'Exact Match'. I understand your confusion about "and" condition; but because of same field condition and majorly the exact match thing its not working properly. You have the following two options:

1.Change conditions to, same first 3 characters and same last 3 characters; remove excat match

2.If your serial No. has defined no. of characters, create a rule with condition; same first 'x' characters
Daniel at VNS on at

Like (0)

Report

RE: Duplicate detection rules not making sense

Good catch - I need some sleep! I posted the picture before my last change. Below is the config and I wish it were this simple. As you can see, fields match, input is <3 characters and we still get the error. There are no other dup detection rules on this entity.
Suggested answer

PS 23,577 on at

Like (0)

Report

RE: Duplicate detection rules not making sense

Your rule shows two different fields, but your post says that you have two conditions for the same field.

Am i missing something?