Current Query Demo

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 any rows where the Employee is Robert King or Andrew Fuller and where the Order Cost is over $1000.

We have created 2 other queries which we have shared - and one is used for a Conditional Style

Generating dummy data, please wait ...