Filter records [AX 2012]

Updated: October 10, 2011

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.

  1. Select the field that meets the criterion for the filter that you want to apply.

  2. Click File > Edit > Filter > Filter By Selection or press ALT+F3.

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

  1. Select the field to use as the filter.

  2. Click File > Edit > Filter > Filter By Field or press CTRL+K.

  3. In the Filter: Name of the field dialog box, enter the filtering criteria, and then press ENTER.


Repeat steps 1 through 3 to apply more filters to the records.

  1. Click File > Edit > Filter > Filter By Grid or press CTRL+G to open the filter line at the top of the grid.

  2. Press TAB to select the column to filter by.

  3. Type the filter criteria, and then press the DOWN ARROW key to select a filtering option.

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


The Remove Filter/Sort option is available on the Edit menu only if a filter is applied.

  1. Create a filter by using one of the filtering options.

  2. Click File > Edit > Filter > Save filter as.

  3. In the Save inquiry dialog box, type a name for the filter that you created.


    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.


The list of filters is empty if you have not saved any filters in the active form or list.

  1. Click File > Edit > Delete filter, and then select a filter to delete.

  2. In the Delete filter dialog box, click Yes to delete the selected filter, or click No to cancel the operation and keep the filter.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions