Programming Microsoft Dynamics NAV - Fifth Edition

SETFILTER function

SETFILTER is similar to, but much more flexible than, the SETRANGE function because it supports the application of any of the supported NAV filter functions to table fields. SETFILTER syntax is as follows:

Record.SETFILTER(FieldName, FilterExpression [Value],...);

The FilterExpression consists of a string (Text or Code) in standard NAV filter format, including any of the operators < > * & | = in any legal combination. Replacement fields (%1, %2, ..., %9) are used to represent the values that will be inserted into the FilterExpression by the compiler to create an operating filter formatted as though it were entered from the keyboard. Just as with SETRANGE, prior to applying its filter, the SETFILTER function clears any ...