conditions.txt 640 Bytes
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
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
LE GAC Renaud's avatar
LE GAC Renaud committed
8
history table.
9

LE GAC Renaud's avatar
LE GAC Renaud committed
10 11 12 13 14 15
    .. warning::

        Do not use foreign fields, virtual fields, keys of the
        ``history.data`` dictionary as well as the pseudo field year.

Example of smart query:
LE GAC Renaud's avatar
LE GAC Renaud committed
16

17
    .. code::
LE GAC Renaud's avatar
LE GAC Renaud committed
18

LE GAC Renaud's avatar
LE GAC Renaud committed
19
        history.id_events = 7 and id_people_categories not in 1,11,13,14
LE GAC Renaud's avatar
LE GAC Renaud committed
20

21
Possible operators are given :ref:`Appendix E`.