Query is a very powerful function that uses an 'Expression' to search across mutliple columns using many functions and operators.
When the Query runs, AdapTable will only display those rows that match all of the Conditions in the Query.
In this example we are searching for the following query:
( [ShipCountry] IN ("UK", "USA") AND ENDS_WITH ([ShipVia], 's') ) OR [ItemCount] < 5)
This will find any rows where the either both the ShipCountry is UK or USA or ShipVia ends with the letter 's'; or where the ItemCount is less than 5.