duplicate detection rule "doesn't see" changing on no. of characters for a field

(0) Share

Report

Posted on by Anna Zasadzka

120

Hi all!

I have a question. I need to set up a duplicate detection rule for a custom entity. One field is an option set - matchcode 255 length, second field is text with 200 characters, which is too much for system (max length - 450). So I've changed no. of characteres in the text field to 180 and went back to duplicate detection rule. But there is no change - matchcode for text field is still 200 characters.

I've tried cleaning cache, restarting login, different browsers and nothing, detection rule "sees" this text field as 200 characters.

Could someone tell me why and how to change it?

*This post is locked for comments

All responses (13)

Answers (1)

Suggested answer

gdas 50,085 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Hi Ann,

Seems this is by design , I replicate the same in my trial instance its holding initial field length not the updated one . Might be this is due to the existing data which can be available in the DB for the entity and its force to apply rule for those records as well.
Anna Zasadzka 120 on at

Like (1)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Ravi,

Thanks for your help. As always, this is Microsoft...;)
Verified answer

RaviKashyap 55,410 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Hi Ann,

Read about it here - docs.microsoft.com/.../detect-duplicate-data

There is also a note around the match code which goes like this-

"After publishing a duplicate detection rule, increasing the length of fields that are included in the duplicate detection criteria goes undetected. The field length could exceed the matchcode length limit and not be verified. This may result in duplicates not being detected."

Trust me I had lot of time on this when =I encountered this and ended up using the same first chracter logic. It worked fine, passed UAT and deployed to production :)

Hope this helps.
Anna Zasadzka 120 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

I've tried all suggested actions and nothing works, except this with first letters, so I think I would have to use first characters rule.

The strange thing is that for some txt fields (with the same setup) matchcode refreshes without a problem after length changing on a field, and for some it doesn't work. Do any of you know how matchcode works for different types of fields?
Suggested answer

RaviKashyap 55,410 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Hi,

The other option would be to change the rule i.e. instead of saying "Exact match", use "Same First Characters" and then enter no. of characters.

Hope this helps
Suggested answer

gdas 50,085 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Please do following step-

- Unpublish duplicate detection rule.

- Publish All customization.

- Press ctrl+F5 browser to refresh, you can also try in different browser.

- Create new duplicate detection rule or publish existing rule.
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Publish all customization and also publish duplicate detection rule.

Delete old duplicate detection rule.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Please publish all customizations from the default solution and create a new Dupe rule.
Anna Zasadzka 120 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

1. original max length for a field:

2. I've created on duplication rule for a field before changing max length:

3. then I've changed max length for the field to 150 and published changes:

4. then I've created new duplication rule - matchcode still the same:

I also created new text field and was changing max length and matchcode was changing along...
Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: duplicate detection rule "doesn't see" changing on no. of characters for a field

Please share screen shot if possible.