How to: Add Controls to the Filter Pane [AX 2012]
Updated: June 22, 2011
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
A list page includes a default filter pane that enables you to search the records in the data grid. By default, you can search based on one of the columns displayed in the data grid. To create a filter that is based on multiple values in the data source query, you have to add controls for those fields to the filter pane. For example, the following illustration shows two controls that were added to the filter pane of the Collections list page.
The values in the controls are used to filter the records that appear in the list. To add controls to the filter pane, follow these steps.
To add a control to the filter pane
In the AOT, expand Forms, expand the list page form, expand Designs, and then expand Design. Click the Filter group control and set the Visible property to Yes.
Right-click the Filter group control, click New Control, and then click the type of control you want to add. For example, click ComboBox to add a control that enables you to select a value from a list.
If the filter pane contains other controls, use the ALT+UP ARROW or ALT+DOWN ARROW to change the position of the control that you added.
Right-click the control, and then click Properties. If you want the control to include a list of values that you can click, add an extended data type (EDT) or enumeration to the control properties.
To add an EDT or enumeration, use the Properties window to specify the value for one of the following properties.
Click the name of the enumeration.
Use EnumType when you want to open a list of enumeration values from the control.
Click the name of the EDT.
Use ExtendedDataType when you want to open a list of EDT supplied values from the control.
The use of an EDT or enumeration is optional and does not apply to all kinds of controls.
To filter the data source query, you connect the value of the control to the value in a data field of the list page data source. To associate the control with a data field, populate the following properties of the filter control that you added.
Click the data source that includes the data field you want to associate with the filter.
Click the data field that includes the values that you want to use to filter the query.
Typically, you use the default value.
However, you can enter an expression that includes additional filter values. You use the same expression syntax that you use with a query range expression. For information about query range expressions, see Using Expressions in Query Ranges.
Select a label that describes the values that are used to filter the list.
Right-click the list page form, and then click Save.
Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.