Filtering in Queries and Tables

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 19:29, 14 October 2007 (edit)
Lorinda (Talk | contribs)
(create article)
← Previous diff
Current revision (08:27, 18 June 2008) (edit) (undo)
( | contribs)
m (correct typos - criterIa, indentifIed)
 
(3 intermediate revisions not shown.)
Line 1: Line 1:
 +{{TBBA Header}}
 +
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. 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.
Line 6: Line 8:
#Set the {{prefName|Field Name}}, {{prefName|Condition}}, and {{prefName|Value}} fields as needed for your filter. If using more than one criterion, you also need to set the {{prefName|Operator}} for the all but the first criteria. #Set the {{prefName|Field Name}}, {{prefName|Condition}}, and {{prefName|Value}} fields as needed for your filter. If using more than one criterion, you also need to set the {{prefName|Operator}} for the all but the first criteria.
#Click {{Button|OK}} #Click {{Button|OK}}
-#The table adjusts, showing only those records that meet the critera.+#The table adjusts, showing only those records that meet the criteria.
#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). #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).
Line 38: Line 40:
|'TRUE' |'TRUE'
|- |-
-|Birds identifed by Voice but not by Sight+|Birds identified by Voice but not by Sight
| |
|Voice |Voice
Line 49: Line 51:
|<> |<>
|TRUE |TRUE
 +|}
Many other combinations are possible. Many other combinations are possible.
 +
 +{{botlangbarEN|[[Fr:Trier dans les Requêtes et les Tables|Français]]}}

Current revision

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.

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).

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