Filter records
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
You can use filtering to find and work with a subset of the data in a form. When you apply a filter on a form, you see only the records that meet the criteria that you specify.
For example, you can filter the records on the All customers list page so that only customers from a specific customer group are displayed.
The following commands are used to filter records:
Filter By Selection (ALT+F3)
Filter By Field (CTRL+K)
Filter By Grid (CTRL+G)
Advanced Filter (CTRL+F3), for more complex criteria
Unlike sorting, filtering does not rearrange the records. Filtering temporarily hides records that you do not want to display in a grid.
Select the field that meets the criterion for the filter that you want to apply.
Click File > Edit > Filter > Filter By Selection or press ALT+F3.
Note
Filter By Selection removes any filter that is applied to the table and finds all records that meet your search criteria.
Filter By Field is similar to Filter By Selection, except that you can specify the filtering criteria for the field.
Select the field to use as the filter.
Click File > Edit > Filter > Filter By Field or press CTRL+K.
In the Filter: Name of the field dialog box, enter the filtering criteria, and then press ENTER.
Note
Repeat steps 1 through 3 to apply more filters to the records.
Click File > Edit > Filter > Filter By Grid or press CTRL+G to open the filter line at the top of the grid.
Press TAB to select the column to filter by.
Type the filter criteria, and then press the DOWN ARROW key to select a filtering option.
Repeat steps 2 and 3 to add more criteria to the filter.
To remove a filter that is applied to one or more columns in the form, click File > Edit > Remove Filter/Sort or press CTRL+SHIFT+F3.
Note
The Remove Filter/Sort option is available on the Edit menu only if a filter is applied.
Create a filter by using one of the filtering options.
Click File > Edit > Filter > Save filter as.
In the Save inquiry dialog box, type a name for the filter that you created.
Note
To save changes to an existing filter, click File > Edit > Filter > Save filter.
To apply a filter that you previously saved, click File > Edit > Apply filter, and then select a filter in the list.
Note
The list of filters is empty if you have not saved any filters in the active form or list.
Click File > Edit > Delete filter, and then select a filter to delete.
In the Delete filter dialog box, click Yes to delete the selected filter, or click No to cancel the operation and keep the filter.