All of the criteria that perform selections based on SQL field values have a certain number of operators available for their use.
{field operator value}
Here is a list of the simple operators:
-
=: equality operator{id_rubrique=8}selects records with "id_rubrique" equal to 8. -
>: strictly greater than operator.{id_rubrique>8}selects records with "id_rubrique" greater than 8. -
>=: greater or equal operator.{id_rubrique>=8}selects records with "id_rubrique" greater than or equal to 8. -
<: strictly lesser than operator .{id_rubrique<8}selects records with "id_rubrique" less than 8. -
<=: lesser or equal operator.{id_rubrique<=8}selects records with "id_rubrique" less than or equal to 8. -
!=: not equal operator{id_rubrique!=8}selects records with "id_rubrique" different from 8.