When entering filter values in the filter pane in the Business Central web client, users can enter filter tokens [% + reserved word] that resolve to a filter value or a filter expression. The reserved word can be written in small letters or completely in capitals, or even be translated – more on that soon.
I wrote in the past some articles about how it’s important to use Azure Storage for storing files in a Dynamics 365 Business Central project (avoid using blobs and media as much as possible) and I’ve talked about the differences between Azure Blob Storage and Azure File Share, also providing a solution for mapping an Azure File Share as a local drive for data exchange with Dynamics 365 Business Central (link here).
A few days ago, I was asked an interesting question, how to combine “Not equal to” format expressions when entering Criteria in Filters (Not equal to multiple criteria). This is not a very difficult question. In this post, I would like to briefly share information about how to enter criteria in filters in Business Central.
FilterPageBuilder Data Type
Version: Available or changed with runtime version 1.0.
Stores filter configurations for a filter page. A filter page is a dynamic page type that contains one or more filter controls that enable users to set filters on fields of the underlying tables.