5
R

Improve "Filter to this Value"

Rob Hansen on 11/13/2018 2:03:33 PM
I've always thought the implementation of the quickfilter was poorly done. Users can only right-click on a single field to "filter to this value". When a second one is done, it replaces the first. When "filter to this value" is used, i would much rather see it add the filter as an advanced filter. Users could then use the function on multiple fields to add multiple advanced filters easily.
Category: General
STATUS DETAILS
Completed
Ideas Administrator

Business Central Team (administrator)

Good news! We've made this available in the Web client and Windows store app as part of the October '18 release for Business Central.
You can now use the Alt+F3 keyboard shortcut, or select the 'Filter to this Value' menu item from the column header, to incrementally add to your filters. We've taken it a step further: hitting Alt+F3 again on the same field will remove it from the filter (essentially a toggle), and Shift+Alt+F3 will add the current field to the filter without setting a value, allowing you to quickly type a range or expression. Combined together, these make analyzing lists or finding your data extremely quick and efficient.

Find other keyboard shortcuts at https://aka.ms/bckeys
Learn about what else is new in the October '18 update for Business Central at https://aka.ms/0bcr1

Best regards,
The Business Central team

Comments

R

R

RE: Improve "Filter to this Value"

Wilfred de Ridder on 11/15/2018 11:28:10 AM

You mean it should be working like Excel? Filter to this value is usable on multiple columns without select from a filterlist.

Category: General

R

R

RE: Improve "Filter to this Value"

Kamil Sacek on 11/14/2018 7:55:25 AM

I will suggest to solve this by functionality like "Refine list" when there is already some filter. It will "Add" the filter to the advanced filters. It means current functionality for "filter to this value" will be same, but new function will allow user to refine the filters.

Category: General