Using the Advanced search, users can search for features based on more than one value.
For example, a user might want to see Delivery Gates that have been identified to be either Replaced or Removed . The following query can be used:
Select from ‘Delivery Gates’ where
status_action = 'Replace' OR status_action = 'Remove'
Features can also be selected based on values from different attribute fields. For example, a user might want to view only Active meters that are on the Left side of the canal.
Select from ‘Meter’ where:
side_of_canal = 'Left' AND life_cycle_status = 'Active'