conditions.txt 1.08 KB
Newer Older
1
.. include:: hyperlinks.txt
2 3 4

The fitler conditions is defined in the ``General`` tab.

LE GAC Renaud's avatar
LE GAC Renaud committed
5 6 7 8
The ``Conditions`` are used to select a sub-sample of the history records. It
is based on the smart_query_ available in the Web2py_ framework. The query
is written in the natural language, but it is limited to field of the
history table. Fields of the foreign tables, virtual fields or keys of the
9 10
``history.data`` dictionary can not be used.

LE GAC Renaud's avatar
LE GAC Renaud committed
11
The ``changelog`` event introduced earlier has the ``id`` equal to 7. To
12
select history related changelog events, enter::
LE GAC Renaud's avatar
LE GAC Renaud committed
13

14
    history.id_events = 7
LE GAC Renaud's avatar
LE GAC Renaud committed
15

16 17 18 19
The following operators are understood:

* ``&``, ``and``
* ``|``, ``or``
LE GAC Renaud's avatar
LE GAC Renaud committed
20
* ``~``
21 22 23
* ``==``, ``=``, ``equal to``, ``equal``, ``equals``, ``is``
* ``<``, ``less than``
* ``>``, ``greater than``
LE GAC Renaud's avatar
LE GAC Renaud committed
24
* ``<=``, ``=<``, ``less or equal than``, ``equal or less than``,
25
  ``less or equal``, ``equal or less``
LE GAC Renaud's avatar
LE GAC Renaud committed
26
* ``>=``, ``=>``, ``greater or equal than``, ``equal or greater than``,
27 28 29 30
  ``greater or equal``, ``equal or greater``
* ``<>``, ``not equal to``, ``not equal``
* ``starts with``
* ``ends with``
LE GAC Renaud's avatar
LE GAC Renaud committed
31 32
* ``contains``
* ``in``
33
* ``not in``
LE GAC Renaud's avatar
LE GAC Renaud committed
34