Filtering Layers in the Attribute Table

This topic on attribute table filtering includes the following sections:

Set and Apply a Filter

To filter results in the Attribute Table widget attribute table :

  1. Open the Attribute Table using the Attribute Table widget attribute table located in the bottom right of Map Studio.

    the attribute table button is located in the bottom right of map studio.

  2. Select Optionsoptions and click Advanced Filtering to open the Filter dialog box.

    The attribute table is open with the Options button visible in the top right and Advanced Filtering visible in the Options menu.

  3. From the Filter dialog box, select Add a filter expression to add one or more filter criteria, or Add an expression set to add multiple filter criteria.

    filter dialog box with options in the top left to add a filter expression or add an expression set.

  4. Populate the filter parameters and click OK in the bottom right to apply the filter. More information on filter parameters is listed below for Add a filter expression and Add an expression set options.

    Both filter options shown side by side. Left is the Add a filter expression interface center with fields and the OK button in the bottom right. Right is the Add an expression set interface with fields in center and the OK button in the bottom right.

Filter Expressions

This section describes :

Add a filter expression

  1. In the first (far left) dropdown menu, specify a field from your dataset to filter by.

  2. Select an operator by which to filter such as "is," "is not," "contains," "does not contain," etc.

  3. Use the select box to specify whether you are filtering a value, "field", or "unique." The "field" and "unique" options are both populated based on your data.

  4. Select OK in the bottom right to apply your filter.

    add a filter expression with fields to select a field, operator, and the data being filtered.

  5. When the filter is applied, the Filter dialog box closes and a Filters Active indicator is visible in the top of the attribute table next to the Options button.

    Filters Active indicator visible to the left of the Options button.

Add an expression set

  1. Specify whether "all" or "any" of the following expressions in the set are true.

  2. In the first (far left) dropdown menu, specify a field from your dataset to filter by.

  3. Select an operator by which to filter such as "is," "is not," "contains," "does not contain," etc.

  4. Use the select box to specify whether you are filtering a value, "field", or "unique." The "field" and "unique" options are both populated based on your data.

  5. Repeat steps B through D for the second set of filter expressions.

  6. (Optional) Add an additional expression if needed. To remove an expression set, click the red remove Remove button to the right of the set.

  7. Select OK in the bottom right to apply your filter.

    add an expression set fields.

  8. When the filter is applied, the Filter dialog box closes and a Filters Active indicator is visible in the top of the attribute table next to the Options button.

    Filters Active indicator visible to the left of the Options button.

Removing a Filter

To remove an active filter:

  1. Select Options options and click Advanced Filtering to open the Filter dialog box.

  2. Click the Clear filters button in the top right.

    The Clear filters button, in red, located in the top right of the Filter dialog.

  3. Once the Clear filters button is clicked the Filter dialog will close and the filters will no longer be applied. This can be confirmed by the absence of the Filters Active indicator to the left of the Options button.

    Filters Active indicator is no longer visible to the left of the Options button.