Skip to main content

Yes/No/All

Usage​

A Yes/No/All filter allows the selection of either Yes, No or All.

image-400 image-400

The filter is used as a condition on a boolean expression, whereby a selection of Yes resolves to the value true, a selection of No resolves to the value false and a selection of All is equivalent to "No selection".

Syntax
{[<boolean_expr>]=<filter_variable_name>}

For example:

... WHERE {enabled=enabled_filter} ...

A selection of Yes results in database-specific SQL equivalent to:

... WHERE enabled = TRUE ...

Analogously for a selection of No (FALSE). A selection of All results in the tautological condition 1=1.

Configuration​

To configure a Yes/No/All filter, select the Yes / No / All UI control type in the filter definition dialog.

Edit Yes/No Filter Edit Yes/No Filter

Use the Configuration tab to set the filter's default value.

The Value Type of a Yes/No/All filter is always Boolean.

Value Selectors​

A value selector allows to tap into SQL value expressions associated with the checkbox.

Value​

SELECT {my_yes_no_all.value}

The .value selector produces a boolean expression corresponding to whether Yes or No is selected. A selection of All produces NULL.