User Guide : Designing and Executing Map : Setting Up Source Data : Defining and Applying Filters to Source Data
 
Share this page             
Defining and Applying Filters to Source Data
You can data filters to filter your source data. Filters are EZscript expressions.
To define and apply a filter:
1. In the map file, go to the Sources tab > Define Filters section.
2. Click /download/attachments/23921988/Map_Source_Add_Icon.png?version=1&modificationDate=1484737955069&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 source.
N records - Applies the filter to a specified set of records in the source. 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/24975457/SelectIcon_WithinField.png?version=1&modificationDate=1487964313321&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/24975457/Map_Source_Delete_Icon.png?version=1&modificationDate=1490093920070&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/24975457/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1490823733888&api=v2 to move the data filter up.
Click /download/attachments/24975457/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1490823749816&api=v2 to move the data filter down.
6. Click Save to save the changes.