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:
- USA - finds records that contain "USA" in any column.
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:
- Germany Spain - "Germany" and "Spain" in any column.
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:
- "Bottom-Dollar Markets" - finds records that contain the phrase "Bottom-Dollar Markets" in any column.
In Specific Columns Only
Enter a column name before the keyword followed by a colon (without space):
- URL:google - finds records that contain "google" in the "URL" column only.
- URL:users profile - find records that contain "users" in the "URL" column and "profile" anywhere else.
- "Dropbox" -URL:google - finds records containing "Dropbox", but not in URLs containing "google".
Users can enter incomplete column names. In this case, the grid displays records from the first column whose name matches the entered string.
- Page:inbox - finds records containing "inbox" from the first column whose name starts with "Page" ("Page Title" in this case).
To specify the exact name of a column, or if the name contains multiple words, use quotes or brackets:
- "Page Title":login - "login" in the "Page Title" column only.
- [Page Title]:login - "login" in the "Page Title" column only.
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:
- [Page Title]:'[Year 1597]' '"Romeo and Juliet"' - finds records that contain [Year 1597] (with brackets) in the "Page Title" column and "Romeo and Juliet" (with double quotes) in any column.
- "Page Title":"[Year 1597]" "'Romeo and Juliet'" - find records that contain [Year 1597] (with brackets) in the "Page Title" column and 'Romeo and Juliet' (with single quotes) in any column.
Options and Modifiers
Overriding Comparison Operators
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". |
Overriding Parsing Mode Using Modifiers
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". |