Field restriction

With this restriction, a search can be undertaken by means of a Projection, a comparison type and a Wertes.

Example:

Here a field Projection (numberOfPackages of the shipment) is used and checked with > for the value 10.

images/download/attachments/162410166/image2018-5-16_9_14_24-version-1-modificationdate-1702906835191-api-v2.png

The following comparison types are available

Comparison type	Description
==	equal
=	equal
!=	unequal
<	less than
<=	less than or equal to
>	greater than
>=	greater than or equal to
like	equal to 'text pattern' (space holder: %) Pay attention to use of upper or lower case letters
not like	unequal to 'text pattern' (space holder: %) Pay attention to use of upper or lower case letters
ilike	equal to 'text pattern' (space holder: %) Use of upper or lower case letters is irrelevant Attention: This search does not use an index and is thus considerably slower
not ilike	unequal to 'text pattern' (space holder: %) Use of upper or lower case letters is irrelevant Caution: This search does not use an index and is thus considerably slower
in	equal to 'value list'
not in	unequal to 'value list'
between	in between