Filtering string fields

This is the most basic case.

The filter condition will be :
<FieldName> <Operator> <Value>

Example :
EquipmentName StartsWith Blender

Operators

Operators appropriate to Strings can be selected.

Values

Static values

The “Edit values” button can be check/unchecked manually :

When the “Edit values” button is un-checked, a value can be selected from current values in the database :

When the “Edit values” button is checked, a value can also be entered as text :

*Depending on the operator selected, some of these options may not be available.

Dynamic filter values using Parameters

Instead of comparing to a static value, it is possible to compare to a dynamic Parameter that will depend on actions inside the Dashboard.

For this, select “Use Parameter” and see the Chapter about Parameters.

Code192 2020 All rights reserved