Quick Search makes it easy to find all instances of a specific value or term in a grid. You simply enter the value/term you want to search for, and the Adaptable Blotter will find it.
Depending on the Quick Search settings you have in place, the Blotter will highlight the matching cells, will filter the grid so that it only shows those rows that have matching cells, or do both.
You should use Quick Search when you want to search in all columns and all rows of a grid.
Quick Search is a one time operation - so it will highlight / filter the cells at the time that the Search is applied. Unlike with Advanced Search or Column Filters it will not get applied when data or column changes are made in the grid.
To perform a quick search on your grid enter the text that you want to search for in the Quick Search Function Toolbar.
AdaptableBlotter.JS applies the search as you type.
In the image below the user has typed 'bank' into the textbox.
Depending on what Quick Search settings are in place, AdaptableBlotter.JS will highlight matching entries, filter the grid so that you can only see rows with matching entries, or a combination of both.
You can Clear the Quick Search by clicking the close icon in the right hand side of the Textbook.
You can use the same wildcards as the Floating Filter to refine your quick search. For example, '> 500' will return any cell that has a number greater than 500. Or 't*' will return any cell that starts with t. See Floating Filter for more information on using wildcards.
The 'Between' and 'In' Floating Filter wildcards are not available in Quick Search.
Click the Edit button in the Quick Search Function Toolbar to open the Quick Search popup. Alternatively you can access it from the Functions Dropdown or the Quick Search Function Shortcut.
Use the Behaviour dropdown to control how matching values are shown in the grid.
Choose Highlight Cells Only if you want matching values to be highlighted. The grid shows all rows but highlights those cells which have matching values.
Choose Show Matching Rows Only if you want to filter the grid, so that it only shows rows that contain the search text. Any values that match the search text are not highlighted, and rows that do not contain the search text are not shown.
Choose Highlight Cells & Show Matching Rows if you want matching values to be highlighted and you want the grid to only show those rows that contain the search text.
Use the Back Colour setting to choose the highlight colour of matching cells and / or the Fore Colour setting to set the font colour.
These colours will be applied to cells that contain a value that matches the search text (if the Display setting is Colour cells that match search text or Display matching rows and colour cells).
You can choose from the list of available colours or click Other to access the colour palette, where you can specify a colour of your own choice.
You are also able - for some grids - to set a css style classname for Quick Search instead of setting the properties individually.