Documentation
Operators : equals, contains, etc.
The differents operators that can be used to express conditions on the fields of an element
Possible operators are :
- = : equals
- contains or LIKE: contains (with or without the exact accents)
- match : equals but with or without the exact accents
- matchagainst : same as contains, but using the MySQL fulltext index feature (faster).
- not contains
-
starts-with
(only for strings) - ends-with
- > ou GT : greater than
- >= ou GT= : greater or equal
- < ou LT : lower than
- <= ou LT= : lower or equal
- NE ou != ou <> : different
- between: between 2 values (the two values are separated by a slash "/" )
- IN: in a set of values (values are separated by commas "," )
- NOT IN : not in the set of values given (values are separated by commas "," )
- MD5 : a MD5 of the value encoded in Nectil is equal to the value given for the field (can be used to hide values from user).
Default operators are :
- equals (=) for numbers and dates
- contains for strings
Strings handled as numbers :
If you have text fields that contains numbers you better use the operator modifier "number" because when considered as a string "989" is lower than "99" (alphabetical order).
<SEARCH>
<MEDIA>
<DESCRIPTION>
<HEADER operator="LT number">100</HEADER>
</DESCRIPTION>
</MEDIA>
</SEARCH>
The "number" modifier must be appended at the end of the standard operator (=, GT, LT, etc) after a whitespace.