Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Data Binding
   [Expand]Views
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Sorting
   [Expand]Filter and Search
   [Expand]Summaries
   [Expand]Focus and Selection Handling
    Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
    Split Presentation
    Row Preview Sections
    Scrolling
   [Expand]Batch Modifications
   [Expand]Hit Information
    Hints
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Collapse]End-User Capabilities
     End-User Capabilities: Data Editing
     End-User Capabilities: Locating Rows Using Incremental Search
     End-User Capabilities: Controlling the Visibility of Columns, Bands and Card Fields
     End-User Capabilities: Navigating Through Rows and Cells
     End-User Capabilities: Rearranging Columns, Bands and Card Fields
     End-User Capabilities: Resizing Columns and Bands
     End-User Capabilities: Resizing Cards
     End-User Capabilities: Selecting Rows/Cards
     End-User Capabilities: Expanding and Collapsing Rows and Cards
     End-User Capabilities: Sorting
     End-User Capabilities: Grouping
     End-User Capabilities: Filtering
     End-User Capabilities: Filter Editor
     End-User Capabilities: Filter Editor - Building Filter Criteria
     End-User Capabilities: Applying Summaries
     End-User Capabilities: Locating Rows Using Search (Find) Panel
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

End-User Capabilities: Locating Rows Using Search (Find) Panel

The Find Panel provides an easy way of searching against visible columns/card fields. Displayed above the grid, the panel contains a search box where you can type a search string.

Expanded Invoke the Find Panel

  • Ensure that no cell editor is active and press Ctrl+F.

or

  • In Grid Views, choose the Show Find Panel command from a column menu.

Expanded Search

  • Enter a search string in the search box. In most cases, rows are filtered automatically after a short while.
  • In some cases (mostly when the grid is bound to a large amount of data), you need to press the Find button to manually start the search.

The search syntax is described below.

Expanded Clear the Search Box

Press ESC or click the Clear button.

Expanded Close the Find Panel

Click the 'x' button to the left of the search box or:

  • If the search box is empty, press ESC (the shortcut is in effect if the search box has focus);
  • If the search box is not empty, press ESC twice (the shortcut is in effect if the search box has focus).

Expanded Search Syntax

In its simplest form, a search criterion consists of a single word. If you want to search for a string containing a space character, specify this string in quotation marks. Without quotation marks, words separated by the space character are treated as individual conditions.

You can search against a specific column by preceding a search string with the column's display name plus a colon character.

ColumnDisplayName:SearchString

Instead of the complete name, it is possible to partially specify the display name, using the initial characters of a column's display name. A search will be performed against the first column whose display name starts with the specified substring. If you want to search against a column whose display caption contains space characters, specify the column's display caption in quotation marks.

If the search string contains multiple conditions separated by space characters, and at least one condition defines a search against a specific column, only records that match all of these conditions are shown (i.e., the conditions are combined by the AND logical operator). If there is no column specification, records that match at least one of these conditions are shown (i.e., the conditions are combined by the OR logical operator).

Precede a condition with "+" to display only records that match this condition. The "+" specifier allows you to implement the logical AND operator. There should be no space character between the "+" sign and the condition.

Precede a condition with "-" to exclude records that match this condition from the result set. There should be no space between the "-" sign and the condition.

Examples

Search Criteria Description
register Selects records that contain the "register" string in any search column.
check register Dave Selects records that contain either "check" OR "register" OR "Dave" strings in any search column.
"check register" Selects records that contain "check register" in any search column.
screen +"Richard Fisher" Selects records that contain both "screen" AND "Richard Fisher" in search columns.
Product:Tofu Seattle Selects records that contain "Tofu" in the column that starts with "Product", AND also contain "Seattle" in any search column.
data +entry -mark Selects records that contain both "data" AND "entry" in search columns, excluding records that contain "mark".
menu mask -file Selects records that contain "menu" OR "mask", excluding records that contain "file".
From:Roller Subj:"currency mask" Selects records that contain "Roller" in the column that starts with "From", AND also contain "currency mask" in the column that starts with "Subj".
import -From:Steve Selects records that contain "import" in any search column, excluding records that contain "Steve" in the column that starts with "From".
Note

Searches performed using a Find Panel are case insensitive.

How would you rate this topic?​​​​​​​