Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Examples > Filtering > How to: Change the Prefilter Criteria in Code
A newer version of this page is available. .
All docs
V19.1
WinForms Controls
.NET Core Support
Prerequisites
What's Installed
Build an Application
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Data Shaping
Data Analysis
Layout
Focus and Navigation
Printing and Exporting
Appearance
Design-Time Features
Miscellaneous
UI Elements
End-User Capabilities
Examples
Providing Data
Summarization
Sorting
Grouping
Filtering
How to: Apply Filter to a Field
How to: Apply Summary Filter
How to: Prevent End-Users From Changing Filter Conditions
How to: Add and Remove Items From Filter Drop-Down Lists
How to: Implement Group Filter for a PivotGrid
How to: Change the Prefilter Criteria in Code
How to: Sort Filter Drop-Down Items in a Custom Manner
Drill-Down (Underlying Data)
Editing
Layout Features
Formatting
Data Output
Appearance
Serialization
Member Tables
Tree List
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Snap
TreeMap Control
Sunburst Control
Common Features
Get More Help
API Reference
Download CHM

How to: Change the Prefilter Criteria in Code

The following code shows how to filter a Pivot Grid Control’s underlying data source using the Prefilter. The filter selects records that contain ‘USA’ or ‘UK’ strings in the Country field.

using DevExpress.Data.Filtering;

//...

pivotgridControl1.Prefilter.CriteriaString = "[" + fieldCountry.PrefilterColumnName + 
                "] = 'UK' OR [" + fieldCountry.PrefilterColumnName + "] = 'USA'";