User Guide : Designing and Executing Map : Setting Up Target Data : Defining and Applying Filters to Target Data
 
Share this page             
Defining and Applying Filters to Target Data
You can define and apply data filters to filter your target data. Filters are EZscript expressions.
To define and apply data filters:
1. In the map file, go to the Targets tab > Define Filters section.
2. Click /download/attachments/24975459/Map_Source_Add_Icon.png?version=1&modificationDate=1490852595364&api=v2 to add a data filter.
The EZscript Expressions window is displayed, where you can define a filter by adding an expression. For example, Records("R1").Fields("State") == "LA"
For more information, see Scripting.
3. After adding the data filter, it appears in the Define Filters section.
4. From the Apply Filters to drop-down list, select one of the following options:
All records - Applies the filter to all the records in the target.
N records - Applies the filter to a specified set of records in the target. When you select this option, where N Equals appears. Type a value. The maximum value is 2147483647.
5. You can also do the following:
To edit a data filter, click the filter and then click /download/attachments/24975459/SelectIcon_WithinField.png?version=1&modificationDate=1487964330232&api=v2.
The EZscript Expressions window is displayed where you can modify the expression.
To delete a data filter, click the filter and then click /download/attachments/24975459/Map_Source_Delete_Icon.png?version=1&modificationDate=1490111178471&api=v2. A message appears asking for confirmation. Click Yes. The filter is removed from the Define Filters section.
To move the order of the data filters:
Click /download/attachments/24975459/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1490823827568&api=v2 to move the data filter up.
Click /download/attachments/24975459/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1490823839299&api=v2 to move the data filter down.
6. Click Save to save the changes.