List functions

List functions access values in a collection of objects and calculate the number of objects in a specific collection.
Table 1. List functions
Syntax Description Example
<object> is one of <list>
Tests that an object is part of a list.
if the item of order is one of 'discounted items'
<object> is not one of <list>
Tests that an object is not part of a list.
if 'customer category' is not one of 'all categories'
<list> contain <object>
Tests that a list contains an object. This function is equivalent to <object> is one of <list>.
if 'customer categories' contain Platinum
<list> do not contain <object>
Tests that a list does not contain an object. This function is equivalent to <object> is not one of <list>.
if 'customer categories' do not contain Normal
<attribute> of <list>
Accesses a list of attribute values.
if the countries of the addresses of customers contain "France"