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.
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.
Repeat steps 1 through 3 to apply more filters to the records.
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).