The FILTERGROUP function can change or retrieve the Filtergroup that is applied to a table. A filtergroup 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.

Filtergroups can also be used to filter Query Data Items. All the currently defined filtergroups 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 ...

Get Programming Microsoft Dynamics NAV - Fifth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.