changes.mady.by.user Sara Glore
Saved on Apr 05, 2021
...
Wildcard
=
value or .eq value will select all records equal to the value entered
>
value or .gt value will select all records greater than the value entered
>=
value or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields)
<
value or .lt value will select all records less than the value entered
<=
value or .le value will select all records less than or equal to the value entered
<>
value or .ne value will select all records not equal to the value entered
~
value or .like value will select all records starting with the value entered - StatuscoloursubtleRedtruetitleOnly works for text fields; this is the default behavior for text fields if no operator is entered
value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed - StatuscoloursubtleRedtruetitleonly works with numeric fields
value1..value2