If a user wants to add a combined filter for a table field, for example to filter in the customer list for No. = "10000 | 30000", the only way is to enter the entire filter string.
If the user enters "10000 |" in the filter field and then selects the customer no. 30000 in the drop-down list, the value of the filter is replaced by the value "30000".
In the old Windows client, in this scenario, customer number 3000 was added to the previously entered filter and the user received the following filter string "10000 | 30000". This is the behaviour which endusers expect.
Comments
This enhancement is highly needed by many customers who have migrated from NAV to Business Central.Several of our customers have a large number of NAV/BC users, and one of the most common feedback points is the lack of the filter append functionality that was available in Navision. Users are becoming increasingly frustrated because they now need to manually enter and maintain filter values, which consumes significant time and reduces productivity.To address this gap, we have even had to provide customizations for multiple reports without raising formal change requests, simply because customers relied heavily on this functionality in their daily operations.A frequent comment we hear from customers is:"We were able to do this easily in Navision. Why is it not available in Business Central?"During migration discussions, customers are often told that NAV functionality will continue to be available while Business Central brings additional capabilities. Therefore, preserving commonly used and productivity-enhancing features such as filter append would greatly improve the user experience and ease the transition from NAV to BC.I strongly support adding this feature in an upcoming release and believe it would provide significant value to many existing NAV and Business Central customers.
Category: General
This functionality is very needed and missed! The behavior applies not only to the "|" operator but also to range filters using "..". Values selected from the dropdown should be added to an existing filter instead of replacing it, as was the case in the Windows client.
Category: General
This is very needed (and should be simple) feature to add. It gives a very strong customer bad experience. Especially from customers migrating from older version. We constantly need to handle this "negative" side and hear "It supposed to be new system with improved UX". Please add this feature. It should be a quick win.
Category: General
Should have been working from first day, who thought it was ok to skip this functionality..
Category: General
We miss this feature!
Category: General
Please make it come back!
Category: General
Please bring back this feature. Or provide a workaround to select multiple from a drop down list.
Category: General
One of the first things our customers complain about when migrating from Windows client
Category: General
Yes, Those Filter options with (|, ..) were massively used in the previous version please include some in BC as well.
Category: General
This is connected with these two ideas:https://experience.dynamics.com/ideas/idea/?ideaid=eeee26f8-ab34-eb11-8441-0003ff68daffhttps://experience.dynamics.com/ideas/idea/?ideaid=613b26d0-a9e2-ea11-bf21-0003ff68d4ddTogether that's almost 150 votes... A lot of less popular ideas were implemented.We're upgrading a lot of companies last and this year and every user that was working with desktop clients is complaining about it. Please consider putting it on a roadmap, cause it's a great and simple functionality and we deeply miss it...
Category: General

Business Central Team (administrator)