The Find Panel provides an easy way of searching against visible columns and fields. It is displayed above the grid and contains a search box where the user can enter a search string.
Use the following syntax to search for keywords. Queries are not case-sensitive.
Type a single keyword:
The find panel options allow you to specify how words in records should match keywords in the query (start with, contain, etc.). See Overriding Comparison Operators below.
Type multiple keywords separated by spaces:
The find panel options allow you to specify whether the resulting records should contain all keywords in the query or any of them. See Overriding Parsing Mode Using Modifiers below.
Enter the phrase in quotes:
Enter a column name before the keyword followed by a colon (without space):
Users can enter incomplete column names. In this case, the grid displays records from the first column whose name matches the entered string.
To specify the exact name of a column, or if the name contains multiple words, use quotes or brackets:
To include quotation marks, brackets or keyword modifiers in a query, put the query in single or double quotes:
You can override the standard comparison operator for a particular keyword using modifiers.
Modifier | Operator | Example (result may vary depending on the specified operator) |
---|---|---|
* | Contains: Use this modifier for the Find Panel to search for words which contain this text. | *ma co - finds "Germany" and "Cowes". |
^ | StartsWith: Use this modifier for the Find Panel to search for words which start with this text. | ^ma co - finds "Manager" and "Mexico". |
~ | Like. | ~%ma co - finds "Kostroma" and "Cowes". |
= | Equals. | =UK co - finds "UK" exactly and "Cowes". |
Users can override the specified mode for a particular keyword using the following modifiers:
Modifier | Effect | Example (result may vary depending on the specified parser mode) |
---|---|---|
? | Optional keyword. Use this modifier if resulting records should contain all keywords, but a particular keyword is optional. | ?Agent ?Manager London - finds "Agent" or "Manager", but obligatory in "London". |
+ | Mandatory keyword. Use this modifier if resulting records should contain any of the keywords, but a particular keyword is mandatory. | Agent Manager +London - finds "Agent" or "Manager", but obligatory in "London". Agent Manager +*Lo - finds "Agent" or "Manager", but obligatory in "London". "Marketing Manager" +"Carine Schmitt" - finds "Carine Schmitt" and "Marketing Manager". |
- | Exclude keyword. | Manager -Schmitt - finds "Manager", but not "Schmitt". |
<link rel="canonical" href="https://www.digital-detective.net/find-panel-syntax/" /> |