You can add filters to all pages, either by using the Quick Filter or the Advanced Filter. The Quick Filter is enabled by entering criteria in the Type to filter box at the top of a page. This filtering type is used for a fast entry of criteria. The advanced filtering option is available when you click the expand button next to the Quick Filter or when you press F3. All filters are cleared by pressing Ctrl+Shift+A.
Note |
---|
In Microsoft Dynamics NAV Tablet client and Microsoft Dynamics NAV Phone client, you have a Search capability that works in the same way as Quick Filter. |
Important |
---|
Filtering using the Quick Filter works a bit differently than using the Advanced Filter. 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.
|
The following table illustrates some Quick Filter text search examples:
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* | Starts with and case insensitive. | All records that start with man |
Note |
---|
You cannot use a * 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. |
For more information about filter criteria, see Enter Criteria in Filters.
To use Quick Filter on pages
On any page, select the field to which you want to apply the filter, and then press F3.
In the Type to filter box, type a value to filter on.
Press Enter to view the filtered data.
Tip |
---|
For more information about how to work with fields and columns, see Working with Microsoft Dynamics NAV. For more information about how to find specific pages, see Search. |