top of page

How to Filter, Search and Sort Data in NAV 2017 2018 D365

CBR Technology provides Microsoft Dynamics NAV Implementation and Maintenance Services. You can reach us at Tel. (714) 901-5740 or via e-mail at or visit our website CBR Technology.

Searching, Filtering, and Sorting Data

There are a few things that you can do that will help you find, pinpoint, and scan records in a list. These include sorting, searching and filtering.

When you want to search for data, such as customer names, addresses, or product groups, you enter criteria. In search criteria you can use all the numbers and letters that you normally use in the specific field. In addition, you can use special symbols to further filter the results. There are two ways to search: using the Quick Filter or column filters.


Sorting makes it easy for you to get a quick overview of your data. If you have many customers, for example, you can choose to sort them by Customer No., Customer Posting Group, Currency Code, Country Region Code, or Sales Tax Registration No. to get the overview you need.

To sort a list, you can either choose a column heading text to toggle between ascending and descending order, or choose the small downs arrow in the column heading, and then choose Ascending or Descending.

Searching by using the Quick Filter

You can add filters to all pages by using the Quick Filter. The Quick Filter is enabled by choosing the magnifier icon in the top right corner of a page. This filtering type is used for a fast entry of criteria.


The Quick Filter provides an easy access to filter data by entering plain text, but does also provide a lot of search criteria options. Depending on whether you enter plain text or text including symbols, the Quick Filter behaves differently.

  1. If you enter plain text in the search criteria, the search criteria is interpreted as a case insensitive search that contains certain text.

  2. If you enter text including symbols in the search criteria, the search criteria is interpreted exactly as you entered it, and the search is case sensitive.

Quick filter criteria

Search CriteriaIntepreted asReturns…Man@*man*All records that contain the text man and case*se*All records that contain the text se and case insensitive.Man*Starts with Man and case sensitive.All records that start with the text Man.‘man’An exact text and case sensitive.All records that match man exactly.@man*Starts with and case insensitive.All records that start with man.@*manEnds with and case insensitive.All records that end with man.


You cannot use a wildcard when filtering on enumeration fields, such as the Status field on sales orders. To enter a filter for this type of field, you can enter the numeric value as a filtering parameter. For example, in the Status field on a sales order that has the values Open, Released, Pending Approval, and Pending Prepayment, use the values 0, 1, 2, and 3 to filter for these options.

Searching by using column Filters

You can add a filter on one or more columns in a list. Filtering on columns is more flexible and enhanced than the Quick Filter.

To add a filter on a column

  1. Before you add a filter, choose

Show as list
  1. Choose the downwards arrow in the column heading, and then choose Filter.

  2. Do one of the following:

  3. Choose next to the box to select a value from a list.

  4. Enter filter criteria in the box. See the next section for details.

  5. Choose the OK button.

Filter criteria and symbols

When you enter criteria, you can use all the numbers and letters that you can normally use in the field. In addition, you can use special symbols to further filter the results. The following tables show the symbols which can be used in filters.


There may be instances where field values contain these symbols and you want to filter on them. To do this, you must include the filter expression that contains the symbol in quotation marks (”). For example, if you want to filter on records that start with the text S&R, the filter expression is ‘S&R*’.

(..) Interval – Between Values

Sample ExpressionRecords Displayed1100..2100Numbers 1100 through 2100..2500Up to and including 2500..12 31 00Dates up to and including 12 31 00P8..Information for accounting period 8 and thereafter..23From the beginning date until 23-current month-current year 23:59:5923..From 23-current month-current year 0:00:00 until the end of time22..23From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59

(|) Either/or

Sample ExpressionRecords Displayed1200|1300Numbers with 1200 or 1300 – The single Vertical Line is the SHIFT \ character own your US-Standard Keyboard

(<>) Not equal to

Sample ExpressionRecords Displayed<>0All numbers except 0

The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <>A* meaning not equal to any text that starts with A.

(>) Greater than

Sample ExpressionRecords Displayed> 1200Numbers greater than 1200

(>=) Greater than or equal to

(<) Less than

(<=) Less than or equal to

(&) And

Sample ExpressionRecords Displayed>200&<1200Numbers greater than 200 and less than 1200

(”) An exact character match

Sample ExpressionRecords Displayed‘man’Text that matches man exactly and is case sensitive.

(@) Case insensitive

Sample ExpressionRecords Displayed@man*Text that starts with man and is case insensitive.

(*) An indefinite number of unknown characters

Sample ExpressionRecords DisplayedCoText that contains “Co” and is case sensitive.*CoText that ends with “Co” and is case sensitive.Co*Text that begins with “Co” and is case sensitive.

(?) One unknown character

Sample ExpressionRecords DisplayedHans?nText such as Hansen or Hanson

Combined format expressions

Sample ExpressionRecords Displayed5999|8100..8490Include any records with the number 5999 or a number from the interval 8100 through 8490...1299|1400..Include records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).>50&<100Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).

Please feel free to reach out to CBR Technology Corp at or by calling Tel. (714) 901-5740 for additional information.

#DynamicsNAV #Howto

0 views0 comments

CBR Technology Blog

bottom of page