Filtering in Queries and Tables

From NeoWiki

Jump to: navigation, search
This article is part of the To Base and Back Again tutorial series.

You can filter the data you see when viewing tables or queries by using filters. This tutorial provides some examples, using the All Sightings query. The process is the same when working with tables.

[edit] Steps for Filtering

  1. Open the All Sightings query. (in the main database document, click on Queries in the left hand column, then double click on All Sightings).
  2. Click on the Filter button on the toolbar (it looks like a funnel).
  3. Set the Field Name, Condition, and Value fields as needed for your filter. If using more than one criterion, you also need to set the Operator for the all but the first criteria.
  4. Click OK
  5. The table adjusts, showing only those records that meet the criteria.
  6. To turn the filtering off, click on the highlighted green circle with the check mark (Apply Filter) or the red stop sign with an x on the toolbar (Remove filter.sort).

[edit] Filter Examples

Here are some examples of filters you can set with this query:

Goal Operator Field Name Condition Value
Birds seen at a Clamath Falls: Field_Trip_Location Like Clamath Falls
Birds seen after 3/3/1900 Date > 03/03/1900
Birds identified by Voice Voice = 'TRUE'
Birds identified by Voice but not by Sight Voice = 'TRUE'
AND Sight <> TRUE

Many other combinations are possible.

This article in other languages: Français
Personal tools