There are three modes of filtering: Select, Show, and Include. You can set and clear these modes using the corresponding check boxes in the Data Filter.
You can turn off the automatic selection of this option using the Data Filter Select Check preference. See also Changing the Row State in the Data Table After Making Data Filter Selections.
You can turn on the automatic selection of this option using the Data Filter Show Check preference. For details about row states, see the Row State Columns in The Column Info Window.
You can turn on the automatic selection of this option using the Data Filter Include Check preference. For details about row states, see the Row State Columns in The Column Info Window.
There are two additional options when filtering: Auto clear and Conditional. These options are available from the red triangle menu for the Data Filter. For more information, see Red Triangle Options for the Data Filter.