Difference between Setrange and Setfilter

Question

Accepted Answer

Setrange and Setfilter are methods used in Navision to filter records in a table.

Setrange is used to set a single filter on a field, while Setfilter is used to set multiple filters on multiple fields.
Setrange can only be used on primary keys or indexed fields, while Setfilter can be used on any field.
Setrange can only be used to filter for equality, while Setfilter can be used for various types of filters like range, wildcard, or logical operators.
Setrange is faster than Setfilter when filtering on indexed fields.
Example: Setrange('No.', '1000') will filter records where the 'No.' field is equal to '1000'.
Example: Setfilter('No.', '1000..2000|3000..4000') will filter records where the 'No.' field is between 1000 and 2000 or between 3000 and 4000.

Accepted Answer

Setrange and Setfilter are methods that are used to filter data in Microsoft Dynamics NAV (formerly Navision) based on certain criteria. The main difference between the two is how they handle multiple criteria.

Setrange is used to set a range of values on a single field. For example, you can use Setrange to set a range of dates, or a range of item codes. Setrange will limit the results to only those records where the field value is within the specified range.

Setfilter, on the other hand, is used to set filters on multiple fields. With Setfilter, you can set criteria on multiple fields, and the criteria can be combined using AND or OR operators. Setfilter is more flexible than Setrange and allows you to specify complex filtering criteria.

Difference between Setrange and Setfilter

Top CorporateServe Solution Navision Technical Consultant interview questions & answers