=equals to
!=not equals to
> greater than
>= greater than or equal to
<less than
<=less than or equal to
=?unset or equals to (returns true if value is either None or False, otherwise behaves like =)
=like matches field_name against the value pattern. An underscore _ in the pattern stands for (matches) any single character; a percent sign % matches any string of zero or more characters.
like matches field_name against the %value% pattern. Similar to =like but wraps value with „%“ before matching
not like doesn’t match against the %value% pattern
ilike case insensitive like
not ilike case insensitive not like
=ilike case insensitive =like
in is equal to any of the items from value, value should be a list of items
not in is unequal to all of the items from value
child_of is a child (descendant) of a value record (value can be either one item or a list of items).
Takes the semantics of the model into account (i.e following the relationship field named by _parent_name).
parent_of is a parent (ascendant) of a value record (value can be either one item or a list of items).
Takes the semantics of the model into account (i.e following the relationship field named by _parent_name).