Filtering the data source using attributes

During data source filtering, additional filter types allow you to refine which features will be returned for each layer. The attributes filter allows you to define expressions that filter features based on attributes.

Steps:
  1. Start ArcMap.
  2. Open a map document that contains a graphic table element.
  3. Verify that you are in layout view if necessary.
  4. Right-click the graphic table element and click Properties.

    The Table Properties dialog box appears.

  5. If necessary, click the Data Source tab.

    The Data Source tab appears.

    Data Source tab
  6. Click the data source you want to use in the Data Source list on the Data Source tab.

    The chosen data source is highlighted, and the Filters button becomes available.

  7. Click Filters.

    The Data Filters dialog box appears.

    Data Filters dialog box
  8. Click Add Filter on the Data Filters dialog box and click Attributes Filter.
    TipTip:

    You can also right-click in the Filter area and click Add Combine Filter > Attributes Filter.

    The Filter by attributes properties dialog box appears.

  9. Double-click a field name in the list at the top of the dialog box to use it with the query.
  10. Click an operator.
  11. Click Get Unique Values.

    Filter by attributes properties with unique values displayed

  12. Double-click the value in the unique values list to use with the query.
  13. Click OK on the Filter by attributes properties dialog box.

    The Data Filters dialog box appears.

    Attributes filter
  14. If necessary, click the drop-down for Operator and change the operator type.
    TipTip:

    These filters can be logically appended to the base selections using the And, Or, greater than (>), or less than (<) operators (but not the equal to [=] or exclusive or [XOR] operators).

  15. Repeat the steps to add more filters by attributes.
  16. To further refine data source filtering, you can copy, delete, and sort rows; copy cells; or modify properties.
    1. To copy a cell, right-click an operator or filter type cell and click Copy Cell.
    2. To copy a row, right-click an operator or filter type row and click Copy Selected Row.
    3. To delete a row, right-click a row and click Delete.
    4. To sort a row, right-click a row and click Move Up or Move Down.
    5. To modify or redefine the filter configurations you defined previously, right-click a row and click Properties.
    Filter shortcut menu
  17. Click OK on the Data Filters dialog box.

    The Table Properties dialog box appears.

  18. Click OK.

4/17/2012