Making a query by example

  1. From the Record menu in the Attribute Manager, click Query by and then click Example.
  2. In Query by Example window, choose New from the Equation list box.
  3. In the Attributes list, select the attribute you want to use in the query.
  4. Select a relational operator (such as =, >, <, and so on) from the list box next to the Attributes list.
  5. Enable one of the following options: Attribute Values: uses field values in the query Attributes: uses another attribute in the query
  6. Select a value or attribute from the appropriate list.
  7. Enable one of the following options:
    • AND: selects records that are true for both joined statements
    • OR: selects records that are true for at least one of the joined statements
  8. Click Add.
  9. Repeat step 3 to step 8 as needed.
  10. Click Save.
  11. Enter a name for the equation in the Equation name box and click OK.
  12. In the Query by Example window, click OK.

Query by Subset

If you select Query by Subset before using the Query by features (Current, Excluding Current, and Example), the query is limited to the selected records only instead of performing the query on all the records.

Parent topic: Selecting all records that match a value in the current cell
Previous topic: Selecting all records that do not match a value in a selected field
Next topic: Limiting the query to selected records

© PCI Geomatics Enterprises, Inc.®, 2026. All rights reserved.