Filtering is one of the most powerful tools within Business Central. Filtering is the application of defined limits on the data that is to be considered in a process. When we apply a filter to a Normal data field, we only view or process records where the filtered data field satisfies the limits defined by the filter. When we apply a filter to FlowField, the calculated value for that field will only consider data that satisfies the limits defined by the filter.
Filter structures can be applied in at least three different ways, depending on the design of the process:
- The first way is for the developer to fully define the filter structure and the value of the filter. This might be done in a report that's designed to show information on only a selected group of customers, such as those with an unpaid balance. The Customer table would be filtered to report only on customers who have an outstanding balance greater than zero.
- The second way is for the developer to define the...