The FILTERGROUP function can change or retrieve the filter group that is applied to a table. A filter group contains a set of filters that were previously applied to the table by the SETFILTER or SETRANGE functions, or as table properties defined in an object. The FILTERGROUP syntax is as follows:
[CurrentGroupInteger ] := Record.FILTERGROUP ([NewGroupInteger])
Using just the Record.FILTERGROUP([NewFilterGroupInteger]) portion sets the active filter group.
Filter groups can also be used to filter query DataItems. All the currently defined filter groups are active and apply in combination (in other words, they are logically ANDed, resulting in a logical intersection of the sets). The only way to eliminate the effect of a filter group is to remove the filters in a group.
The default filter group for Business Central is 0 (zero). Users have access to the filters in this filter group. Other filter groups, numbered up through 6, have assigned Business Central uses...