Introduction

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.

 

Syntax

Use the following syntax to search for keywords. Queries are not case-sensitive.

Single Keyword

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.

Multiple Keywords

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.

Exact Phrase Matching

Enter the phrase in quotes:

In Specific Columns Only

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:

Including Special Symbols in a Query

To include quotation marks, brackets or keyword modifiers in a query, put the query in single or double quotes:

Options and Modifiers

Overriding Comparison Operators

You can override the standard comparison operator for a particular keyword using modifiers.

ModifierOperatorExample (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".

 

Overriding Parsing Mode Using Modifiers

Users can override the specified mode for a particular keyword using the following modifiers:

ModifierEffectExample (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/" />