Entering Criteria in Filters

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.

Searching 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.

Important: 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.

Quick filter criteria

Search Criteria Interpreted as... Returns...
>man @man All records that contain the text man and case insensitive.
>se @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 Ends with and case insensitive. All records that end with man.
@man*</TD> Starts with and case insensitive. All records that start with man.

Note: 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.

See Also

Work with Dynamics NAV



© 2016 Microsoft. All rights reserved.