[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 With Data Grid and Views
   [Expand]Data Binding
    Unbound Columns
   [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
   [Expand]Scrolling
   [Expand]Batch Modifications
   [Expand]Hit Information
    Hints
    Popup Menus
   [Expand]Saving and Restoring Layouts
   [Collapse]Visual Elements
    [Collapse]Grid Control Elements
      Data Navigator
      Find Panel
    [Expand]View Common Elements
    [Expand]Grid View Elements
    [Expand]Card View Elements
    [Expand]Layout View Elements
    [Expand]Banded Grid View Elements
    [Expand]Master-Detail Mode Related Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Property 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]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Find Panel

Expanded Overview

Users can use the Find Panel to find keywords in data.

Note

Detail view should be maximized to allow search.

Tip

The GridLookUpEdit does not support the Find Panel. To enable the Find Panel for a look-up editor, use the SearchLookUpEdit instead.

Expanded End-user Capabilities

Keyboard operations
Filter and Search modes:

  • press Ctrl+F to open the find panel
  • press Esc once to clear the panel, press it again to close it
  • press the Down Arrow key to move focus from the panel to the grid
Search mode only:
  • press F3/Enter to go to the next result
  • press Shift/Alt/Ctrl+F3/Enter to go to the previous result
Open the panel in code

Expanded Behavior: Search and Filter

You can specify how the Filter Panel shows search results

  • Filter — hides records that do not match the query, and highlights results in the view (optionally)
  • Search — highlights results in the view and on the scrollbar

To specify the behavaior, use the following properties:

Expanded Options

Highlight results

To specify whether search queries are highlighted, use the ColumnViewOptionsFind.HighlightFindResults property.

Specify search queries in code

Operation buttons

Use the following properties to show/hide the operation buttons.

Filter and Search modes: Filter mode only: Search mode only:

Auto-apply search queries

After a user types in the search box, the search starts automatically or manually depending on the underlying data source. To specify this behavior explicitly, use the ColumnViewOptionsFind.FindMode property. The ColumnViewOptionsFind.FindDelay property allows you to specify the delay between entering a query and starting the search.

Expanded Search Syntax

Demo

Run the XtraGrid demo to see the Find Panel in action.

A single or multiple keywords: type a single or multiple keywords separated with spaces. For example:

  • USA — selects records that contain "USA" in any column;
  • Germany Spain — either "Germany" or "Spain" in any column.

Exact match of a phrase: put the phrase in quotes. For example,

  • "Bottom-Dollar Markets" — selects records that contain the phrase "Bottom-Dollar Markets" in any column.

A word or phrase should necessarily present in the results: precede a condition with "+" (no space between them). For example,

  • Agent Manager +London — selected records must contain "London", and either "Agent" or "Manager" in any column;
  • "Marketing Manager" +"Carine Schmitt" — selected records must contain "Carine Schmitt" and "Marketing Manager" in any column.

Exclude keywords: precede a condition with "-" (without space). For example,

  • Manager -Schmitt — records should contain "Manager", but not "Schmitt".

In specific columns only: enter a column name before a keyword followed by a colon (without space). For example,

  • City:Madrid — selects records that contain "Madrid" in the "City" column only;
  • Country:USA Manager — "USA" in the "Country" column and "Manager" anywhere else;
  • "Sales Representative" -City:London — searches for "Sales Representative", but not in "London".
Users can enter incomplete column names. In this case, a control shows records from the first column whose name matches the entered string. For example,
  • Ci:Madrid — selects records that contain "Madrid" in the first column whose name starts with "Ci" ("City" in this case).
To specify an exact name or if a name contains multiple words, use quotes. For example,
  • "Contact Title":Manager"Manager" in the "Contact Title" column exactly;
Keywords that have a column name as a prefix should necessarily present in the results. For example,
  • Country:USA Seattle Portland — selected records must contain "USA" in the "Country" column, and either "Seattle or "Portland" in any column;
  • USA Seattle Portland — selected records contain "USA" or "Seattle" or "Portland" in any column.

Note

Searches performed using the Find Panel are case insensitive.

Expanded Server Mode Limitations

The Find Panel has the following limitations in the Server Mode:

Expanded See Also

Is this topic helpful?​​​​​​​