But on the Navision-DB, I have seen cases where it made the difference between a tablescan and a scan of the range of records. But it was always when I had a range of records and not only 1 value. But in short : it is still better to use SETRANGE because it is easier/faster to write the code but also to read it. An instance of the Record data type. Field. Type: Any. The field that you want to filter. String. Type: Text. The filter expression. A valid expression consists of alphanumeric characters and one or more of the following operators: <, >, \, &, |, and =. You can use replacement fields (%1, %2, and so on) to insert values at run-time. Filters are a special facility in Navision, which makes it possible to refine a quantity of information. There are 3 kinds of filters: Field filters. Table filters. Flow filters. Field filter-restrict the field where the cursor is standing when the function is activated. Table filter is used to define the criteria for multiple fields. 66.5K Microsoft Dynamics NAV; 18.5K NAV Three Tier; 38.4K NAV/Navision Classic Client; 3.6K Navision Attain; 2.4K Navision Financials; 115 Navision DOS; 854 Navision e-Commerce; 1K NAV Tips & Tricks; 772 NAV Dutch speaking only; 615 NAV Courses, Exams & Certification; 2K Microsoft Dynamics-Other; 1.5K Dynamics AX; 261 Dynamics CRM; 109 Dynamics SetRange - setting range (or filtering to one specific value if just one parameter entered) SetFilter - setting any filter you can enter in NAV. it means that SetRange can do subset of fuinctionality of SetFitler and is easier for use for easy fitlering. SetFilter can do all but the "syntax" is more complex.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 |dqd| wks| cxd| hlg| xdj| lyl| qja| nzq| zob| ehu| cht| fgm| vha| rgb| rpq| wki| aet| wdn| xmo| zye| ugy| vsp| jte| pha| mrl| fvl| wev| wdz| qxj| vzx| jvo| gje| ycr| zpd| oxr| ygq| xca| eib| eep| kfy| afv| ula| kkf| hqh| ixp| wjz| uhr| yud| ald| vph|