Improvements to filter expressions

Enabled for Public preview General availability
End users, automatically This feature is released. Feb 1, 2020 This feature is released. Apr 1, 2020

Business value

As the business grows, so does table data in the database, making quick analysis of the data or even finding records more challenging without the right tools. Defining the perfect set of filters can be a time-consuming, iterative process where the ability to persist filters will save having to recreate them the next time they are needed.

Feature details

Business Central 2019 release wave 2 eliminated the need to recreate commonly used filters by allowing users to permanently save filters as a view in the legacy web client. Based on community feedback, we're now improving the filter experience further.

When authoring filters that use expressions, such as date ranges or filter tokens, you can toggle the filter field to display either the expression or the corresponding value. To view the expression again, just set the focus to the filter field by using the keyboard or mouse. This feature applies to:

  • Filters on lists. Here, it is particularly useful when saving list views so that date- or time-sensitive expressions can easily be modified when needed.
  • Filters to filters on report request pages, XmlPort request pages, and similar filter screens.

A filtered list showing one filter expression as values and another expression that is being edited

Try it now

Experience setting and editing a filter expression, such as on the Items list, by signing in to your online environment.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcIdeas.

See also

Save and Personalize List Views (docs)