
Filter editor
*************

This dialog allows you to define filters which are used to select
which rows to display in the data viewer.  A filter may be as simple
as "count = 1" or something more complicated like "any text column
contains 'java', chapters > 10, pages <= 400, and instock is checked".
When you choose a filter from the "Filter" menu, the data viewer is
updated to show only the rows which match the conditions you have
defined.

At the top of the dialog is a text box containing the name of the
filter; changing this renames the filter.  Below that is a list of the
conditions which make up the filter; a row must satisfy all of these
conditions in order to pass the filter.  "Add", "Edit", "Delete",
"Up", and "Down" buttons let you edit the condition list in basically
the same way as the *columns editor* works.  But instead of the column
editor dialog, a condition editor dialog is launched by the "Add" and
"Edit" buttons.  This dialog lets you choose the column whose value to
compare, the comparison operation to use, and the constant value to
compare against.  For text comparisons, there is also a checkbox that
lets you indicate whether the comparison should be case sensitive or
not.  Instead of a single column, you can choose to compare the value
of "Any text column"; if the value of any String or Note column in a
row satisfies such a condition, the row is considered to pass the
condition.  Click "OK"/"Done" to accept the currently shown settings,
or cancel out of the dialog to revert to the previous values (or to
cancel adding a new filter).
