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.
Tag Archives: Filter
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.
One field, two filters, how’s that possible?
Can you apply multiple filters to a single field? Yes, you can. I’m showcasing two different ways in this video. Check it out:
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 …
Be smart about Business Central OData, $filter like a Pro!
In this video, I show to do filtering on OData, at the source, check it out:
How-To Use Month Date Filters
You want to create different Date Filters for full months based on today or your workdate?
Dynamics 365 Business Central offers multiple ways to enter dates and times, including powerful features that accelerate data entry, or help you write complex calendar expressions.
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”.