conditions.txt 1.09 KB
Newer Older
1
.. include:: hyperlinks.txt
2 3 4 5 6 7 8 9 10 11 12 13 14 15

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

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 
``history.data`` dictionary can not be used.

The ``changelog`` event introduced earlier has the ``id`` equal to 7. To 
select history related changelog events, enter::
    
    history.id_events = 7
   
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
The following operators are understood:

* ``&``, ``and``
* ``|``, ``or``
* ``~`` 
* ``==``, ``=``, ``equal to``, ``equal``, ``equals``, ``is``
* ``<``, ``less than``
* ``>``, ``greater than``
* ``<=``, ``=<``, ``less or equal than``, ``equal or less than``, 
  ``less or equal``, ``equal or less``
* ``>=``, ``=>``, ``greater or equal than``, ``equal or greater than``, 
  ``greater or equal``, ``equal or greater``
* ``<>``, ``not equal to``, ``not equal``
* ``starts with``
* ``ends with``
* ``not in``