Dynamics 365 Business Central: Entering Criteria in Filters (Not equal to multiple criteria)

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.

Source : Dynamics 365 Lab
Read more…

A simple way to filter list pages in Business Central using FilterPageBuilder

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.

Source : Ivan Singleton
Read more…

Custom Filter Tokens

As a user of the Business Central you have some constants you can use to filter or insert values. These constants contain useful values for data manipulation such as

* t / today for date field – return current date
* q / quarter for date field filters – return range of the current quarter
* w / week, m / month, y / year …

Source : Tomas Kapitan
Read more…

Business Central API – Filter Child Array Values Using $filter Query Option

I had a difficult time finding an example of this type of API filtering using the OData $filter query option, so I wanted to share an example that I needed for a project.

For context, this is a very simple example of a Business Central API “child array” that I wanted to filter. Technically, I think that OData calls this an “expanded navigation property”.

Source : Steve Endow
Read more…