Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / BC - Filtering bug
Small and medium business | Business Central, N...
Answered

BC - Filtering bug

(0) ShareShare
ReportReport
Posted on by Wouter_Dunnes 55

Hello, 

See: Sorting, Searching, and Filtering Lists - Business Central | Microsoft Learn

man
or
Man		 All records with fields that contain the text man, regardless of the case. For example, Manchester, manual, or Sportsman.

Scenario: Have a record with postcode '1705 RE'

Expected behaviour: filtering on 1705 would display result. 

Actual behaviour in the BC-demo environment:

2023_2D00_02_2D00_13-10_5F00_14_5F00_54_2D00_Business-Central-_2D00_-View-_2D00_-Customers-_2D00_-Dynamics-365-Business-Central.png

2023_2D00_02_2D00_13-10_5F00_15_5F00_22_2D00_Business-Central-_2D00_-View-_2D00_-Customers-_2D00_-Dynamics-365-Business-Central.png

it seems that only typing 1705 gets resolved as '1705'. 

Now; this could be due to being a lookup. But I experience the same for the name field:

pastedimage1676280065658v1.png

pastedimage1676280094580v2.png

  • Greg Enns Profile Picture
    Greg Enns 1,102 on at
    RE: BC - Filtering bug

    Nicely done and thanks for clarifying Zhu. That makes sense now. And yes, that is how BC/NAV has always worked. The simple search works as expected, but once you try to filter, then you must handle all the wildcards and capitalization yourself.

    Thankfully BC does the simple search on all columns whereas NAV had that for only 1 column.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    RE: BC - Filtering bug

    Hi, Greg, there is no problem with the Search function, I think what Wouter is questioning is the Filter function.

    But I later rechecked the documentation and this part of the description is written in Search, so you are right, the documentation is fine.

    Sorting, Searching, and Filtering Lists - Business Central | Microsoft Learn

    pastedimage1676503361004v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Greg Enns Profile Picture
    Greg Enns 1,102 on at
    RE: BC - Filtering bug

    I have BC20 on prem, and the search works exactly as documented. It converts my filtertext to @*filtertext* and then searches on all columns (like a user would expect in a modern UI).

    So I disagree with ZHU--the new UI is NOT supposed to search like the old UI.

     Wouter Dunnes  Have you tried searching on other list pages to see if the same thing happens there? (It's possible there is some custom code that is causing the filters on your page to not work correctly. If it is the same on all pages, then I also recommend posting the bug to MS--but it is not a bug in the documentation.

  • Wouter_Dunnes Profile Picture
    Wouter_Dunnes 55 on at
    RE: BC - Filtering bug

    Hi ZHU,

    thanks for your answer. Yes, it is the same as in previous NAV, but I think in a modern user experience, the way it is written in the documentation is much more suitable for the end-user.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    RE: BC - Filtering bug

    Hi, I have a feeling this is a problem with Microsoft's documentation.
    It seems that the content of Search is copied to Filter. As far as I know, the behavior in Filter is the same as the previous NAV. If you want to search part of the value, you must add *.

    pastedimage1676336355933v1.png

    pastedimage1676336366480v2.png

    pastedimage1676336381367v3.png

    If you have questions about the documentation, you can submit an issue below. This is anyone can submit.

    pastedimage1676336460129v4.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: BC - Filtering bug

    You can connect with your partner to raise a ticket to microsoft.

    Thanks.

  • Wouter_Dunnes Profile Picture
    Wouter_Dunnes 55 on at
    RE: BC - Filtering bug

    That works indeed.

    Do you agree this is a bug? (since documentation states otherwise).

    How can I best report this to Microsoft?

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: BC - Filtering bug

    My apologies if I misunderstood.

    If you try to filter as you are have already done with @*1705* it will definitely work, Let me know if I correctly understand you, or may give me more example to dig out.

    Thanks

  • Wouter_Dunnes Profile Picture
    Wouter_Dunnes 55 on at
    RE: BC - Filtering bug

    Hello Nitin,

    Please check the documentation I posted. 1705 should get resolved as @*1705*  , ada should get resolved as @*ada*

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: BC - Filtering bug

    Hi,

    In the first screen shot you are not putting * after 1705, check please.

    Thanks.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans