Filter on Boolean values

The Boolean data type has two values, basically True and False. It also accepts Blank.

However, in the Filter dialog box you view various combinations of True, False, or empty values.

• Blank: Include records where value is blank.

• True: Include records where value is True.

• False: Includes records where value is False.

Example on Downtime filter dialog box

The check boxes that appear on the Filter Records dialog box depend on the current module and view. The following example is from the Inventory module.

Related topics

• Create a data query with Filter

• Filter on Allowed values

• Filter on Dates