CODEWITHSUNDEEP
dynamics-crmdynamics-crm-2011
rANth
rANth

Reputation: 427

How to eliminate entity view's duplicate values?

I created a custom view for an entity. But it contains duplicate column values.

How can I show only unique values like SQL Distinct?

enter image description here

UPDATE: By default, CRM consider checks for distinct record based on entire row(displayed) not just column.

Upvotes: 0

Views: 1471

Answers (2)

termas
termas

Reputation: 1399

Entity show duplicated values (using views) if the first not null column value is repeated. By default Entity use this first not null column as Primary Key. So if this column has duplicated values it will show the first record duplicated as many times as the Primary key value exists on the view. Solution: edit this view on Entity and change the primary key to a unique column value. :)

Upvotes: 0

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22846

I can try my best to answer you. You have to understand these are not exact duplicates, unless you wanted to show the cases under each student - if that's what you meant.

If you use editable grid, then you will get grouping option. Read more

enter image description here

Otherwise you have to merge duplicate cases or enable duplicate detection to avoid in first place.

Update:

Looks like a reporting requirement, so probably FetchXML SSRS report or PowerBI report can be developed and embedded in this case.

Upvotes: 0

Related Questions