Filtering is one of the most powerful tools within NAV. 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 will only view or process records where the filtered data field satisfies the limits defined by the filter. When we apply a filter to a FlowField, the calculated value for that field will only consider data satisfying 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 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 customers who have an outstanding balance greater than zero. ...