News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Count number of record...

Microsoft Dynamics CRM (Archived)

Count number of records with same data

(0) Share

Report

Report

Posted on by crmrsw15

685

Hi,

I have a requirement to create a view that only contains records that don't have duplicates in a specific field.

i.e. a Contract ID field actually has the same ID when the contract is renewed, meaning several records could exist for the same contract ID. I need to create a view that only shows records that do not have duplicate contract IDs.

To do this I would assume I would need to create a rollup field to count this but cannot see how this is possible.

I could obviously do this with SQL via an SSRS report but would like it to be a view instead. Can anyone point me in the right direction?

Thanks,

Richard

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Count number of records with same data

Hi crmrsw15 ,

you have to create a plugin/custom workflow (on create and update Contract ID field events) which counts all records with same ID and updates all these record with the results (record count).

This way you will filter record with "Record count" = 0.

Please let me know if you solve.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans