Select by Attributes

Previous  Next

---

Tool: Select by attributes

Icon:

Description: This button will open a pop-up for the user to enter and execute a query for searching features by their attributes in the current active layer.

User Interaction:

1. Single-Click on the button.
   
2. The select by attributes pop-up will provide a list of fields for the active layer (1)
3. Single-Click on a field to query from.
4. The field name will be added to the query box (2).
   
5. Single-Click a logical operator (3).
6. The logical operator will be added to the query box (2).
   
7. In the query box (2) enter the attribute value to search for.

Query Examples:

• PINNUM = '964919500488'
• OWNER like '%Asheville%'
• CALCACRE >= 3.5
• OWNER like '%Asheville%'  AND  CALCACRE >= 3.25
• Note: All text searches must use single quotes.
• Note: The text search wildcard is % and requires the logical operator LIKE.

8. Single-Click the execute button (5) to execute the query.
   

Or

10. Single-Click the cancel button (6) to cancel and exit the pop-up.
11. Single-Click the clear text (4) to clear all text in the query box (2).

Requirements:

1. There must be an active layer.
2. All text field values must have single quotes around them.
3. The wild card is a % and requires the logical operator LIKE.

Limitations:

1. There is a limit to 2000 selected features.

Results:

1. After the button is clicked the select by attributes pop-up will appear.
2. After the execute button (5) is single-clicked the selected features will be highlighted on the map, if there is any.
   
   If no features are highlighted then:
3. The user may have to zoom to the selected extent  
   Or
4. The user should check the TOC for the total number of selected features.
   Or
   The user should ensure that there is an active layer and it is visible.
   Or
5. The user should check the validity of the query expression.

User Interface Location:


Pop-up: