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…

Leveraging “Filter Tokens” codeunit to expand Business Central users’ filtering experience

A few weeks back, I watched Erik Hougaard‘s youtube video “Make your own Date Filters in AL and Business Central” and thought of trying it and adding my own bit to it.

First, what was the intention with custom filter tokens?

The standard application comes already with some tokens.

Source : Business Central Musings
Read more…