Query is a very powerful function that uses an 'Expression' to search across mutliple columns using many functions and operators.
The Query can be named, saved and re-used - not only for searching but in other functions use Expressions (e.g. Conditional Style, Export).
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.
We have created 2 other queries which we have shared - and one is used for a Conditional Style