Search
Select by testing the number of bytes in the binary data value in the source field compared to the given value or values, which can be values from a field, a specified value (TRUE or FALSE), or the result of an expression that evaluates to a Boolean value.
- equal (=) - Select records with values equal to the given value.
- not equal (<>) - Select records with values not equal to the given value.
Launch the template by choosing a boolean field in the Select pane and then double-clicking the Search template. When the template launches we can specify options.
Search : equal (=)
Select records with values equal to the given value.
We start with a table with one field of type boolean. We have used the Layers pane to hide the mfd_id field, for a simpler illustration.
With the focus on the table window, in the Select pane we choose the Boolean A field and then we double-click the Search template to launch it.
In the Search template we choose equal (=) as the Condition option. For the Value box we enter TRUE. Or, if we preferred, we could choose another field in the table from the pull down menu in the Value box, or we could choose Expression from the pull down menu to compare to the result of an SQL expression.
For the Action, we use the default replace selection option.
Press Select.
The template selects all records where the Boolean A value is TRUE.
In the example above, we entered a literal boolean value, TRUE, into the Value box.
We start with a table with two fields of type boolean. We have used the Layers pane to hide the mfd_id field, for a simpler illustration.
With the focus on the table window, in the Select pane we choose the Boolean A field and then we double-click the Search template to launch it.
In the Search template we choose equal (=) as the Condition option. From the pull down menu in the Value box we choose the Boolean B field. If we wanted to compare the Boolean A field to a fixed value, we could have chosen Value and then entered a true or false value. Or, if we preferred to compare to the result of an SQL expression, we could have chosen Expression and then entered an SQL expression.
For the Action, we use the default replace selection option.
Press Select.
The template selects all records where the Boolean A value is the same as the Boolean B value.
Search : not equal (<>)
Select records with values not equal to the given value.
We start with a table with two fields of type boolean. We have used the Layers pane to hide the mfd_id field, for a simpler illustration.
With the focus on the table window, in the Select pane we choose the Boolean A field and then we double-click the Search template to launch it.
In the Search template we choose not equal (<>) as the Condition option. From the pull down menu in the Value box we choose the Boolean B field. If we wanted to compare the Boolean A field to a fixed value, we could have chosen Value and then entered a true or false value. Or, if we preferred to compare to the result of an SQL expression, we could have chosen Expression and then entered an SQL expression.
For the Action, we use the default replace selection option.
Press Select.
The template selects all records where the Boolean A value is not the same as the Boolean B value.