This form allows you set filters for the data base. Select database filtering from the data base display table. There is also a Quick filtering option.
|Parts to the DB filters form:|
Create main filter condition. You must create at least one condition before you can filter.
The "Add condition" button moves the filter criteria to the middle box.
Add addition criteria by repeating the process.
Edit the condition in the memo box, for example:
After the condition is added, the "Apply filter" button becomes active and uses the filter on the data set.
The quick filter button accepts the criteria and immediately filters. This is useful for single, simple filters.
Multiple conditions can be added. Each will be on a separate line, and they will be concatenated with an "AND". If you want an "OR", edit the filter display by adding the "OR" manually and then putting the second condition on the same line.
The "*" character acts as a wildcard; thus "M*" in a state field will find MA, MD, MO....
Filters are case sensitive or not, depending on how you set the checkbox.
The Clear button removes all filter conditions.
|Create Time Filter.|
|For a text field with discrete values, you should
select the "Query Field" button. This will give
you a selection box with all the values. You many find
poor quality control in the edit process of data base
creation, with mis-spelled words or multiple variants for
what should be the same coding.
Note in this case that "Cinder cone" and "Cinder cones", and "Complex volcano" and "Complex volcanoes" are used. You can use the wild card to find both variants, as in "Cinder cone*".
Last revision 2/28/2021