Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Suggested answer

Remove Duplicate values in Customer column filter in All Cases View

Posted on by 235

Hello CS Experts,

I was checking the All Cases view in our CS Hub application. I tried to apply a filter in Customer column by setting it equal to Automotive Trading France. I am wondering why there are four duplicate values that are presented. I tried to use each value but only the second in the list returned results.

Is it possible to merge this list into one value?

pastedimage1661325388464v1.png

Warm regards,

Jolas365

  • Suggested answer
    Rahuldubey Profile Picture
    Rahuldubey 105 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    There are only two possibilities for such results 

    1. Duplicate records are present and the filter doesn't have Active/Inactive condition 

    2. Keep the unique as true in fetchxml 

    3. Could you please paste the js you are using for this view ? 

    Please mark this as answer if it helps to fix the issue!!!

  • Suggested answer
    KK-365 Profile Picture
    KK-365 1,010 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Please check your lookup view on Case Customer field.

    Based on that view, please check if the filter to show only active account is available. If not please add that filter and your work will be done.

    Do let me know if you need more details.

  • Jolas365 Profile Picture
    Jolas365 235 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Hello Yuri,

    Yes, we have four duplicate records here, the records have similar Account name, but differ in some other fields like address, contact, SAP Number etc. 3 of these accounts are already inactive. So why are these inactive accounts still appear in the auto-suggestion when I search for customer field and to filter that same customer field.

    Regards,

    Jolas365

  • Jolas365 Profile Picture
    Jolas365 235 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Hello Yuri,

    Yes, we have four duplicate records here, the records have similar Account name, but differ in some other fields like address, contact, SAP Number etc. 3 of these accounts are already inactive. So why are these inactive accounts still appear in the auto-suggestion when I search for customer field and to filter that same customer field.

  • Suggested answer
    KK-365 Profile Picture
    KK-365 1,010 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Hi Jola,

    Try switching the account view as shown below and then search:

    pastedimage1661488256845v1.png

  • Yuri ji Profile Picture
    Yuri ji on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Hi Jolas365,

    After testing, cases with Inactive accounts will also be filtered out.

    Please go to System View "Inactive Account", and check again if there are duplicate accounts.

  • Jolas365 Profile Picture
    Jolas365 235 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Hello Kapil,

    I checked from Account entity and there is only one active account by that name. This particular account is linked to four contact records.

  • Suggested answer
    KK-365 Profile Picture
    KK-365 1,010 on at
    RE: Remove Duplicate values in Customer column filter in All Cases View

    Please switch to Account entity and check in All account view (if the duplicates are present), possiblity you may have inactive duplicates.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans