Advanced Search Demo

Advanced Search is a very powerful function that can run searches across mutliple columns which can then be named, saved and re-used.

It contains an Expression / Query - something used in many AdaptableFunctions) that allows selections to be performed on a mix of Column Values, Filters and Ranges.

When an Advanced Search is applied, 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 Invoiced Cost is over $350 (Range), for Orders this year (Filter) where the Employee is Janet, Margaret or Robert (Column Values).

Generating dummy data, please wait ...