ClauseType Enum

Lists the values that define the types of filter criteria used in the Automatic Filter Row.

Namespace: DevExpress.Data.Filtering.Helpers

Assembly: DevExpress.Data.v23.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

public enum ClauseType

VB.NET

Public Enum ClauseType

Members

Name	Description
Equals	Specifies the Equals filter criteria.
DoesNotEqual	Specifies the Does Not Equal filter criteria.
Greater	Specifies the Greater filter criteria.
GreaterOrEqual	Specifies the Greater Or Equal filter criteria.
Less	Specifies the Less filter criteria.
LessOrEqual	Specifies the Less Or Equal filter criteria.
InRange
NotInRange
Between	Specifies the Between filter criteria.
NotBetween	Specifies the Not Between filter criteria.
Contains	Specifies the Contains filter criteria.
DoesNotContain	Specifies the Does Not Contain filter criteria.
BeginsWith	Specifies the Begins With filter criteria.
EndsWith	Specifies the Ends With filter criteria.
Like	Specifies the Like filter criteria.
NotLike	Specifies the Not Like filter criteria.
IsNull	Specifies the Is Null filter criteria.
IsNotNull	Specifies the Is Not Null filter criteria.
AnyOf	Specifies the Any Of filter criteria.
NoneOf	Specifies the None Of filter criteria.
IsNullOrEmpty	Specifies the Is Null Or Empty filter criteria.
IsNotNullOrEmpty	Specifies the Is Not Null Or Empty filter criteria.
InDateRange
NotInDateRange
IsBeyondThisYear	Specifies the Is Beyond This Year filter criteria.
IsLaterThisYear	Specifies the Is Later This Year filter criteria.
IsLaterThisMonth	Specifies the Is Later This Month filter criteria.
IsNextWeek	Specifies the Is Next Week filter criteria.
IsLaterThisWeek	Specifies the Is Later This Week filter criteria.
IsTomorrow	Specifies the Is Tomorrow filter criteria.
IsToday	Specifies the Is Today filter criteria.
IsYesterday	Specifies the Is Yesterday filter criteria.
IsEarlierThisWeek	Specifies the Is Earlier This Week filter criteria.
IsLastWeek	Specifies the Is Last Week filter criteria.
IsEarlierThisMonth	Specifies the Is Earlier This Month filter criteria.
IsEarlierThisYear	Specifies the Is Earlier This Year filter criteria.
IsPriorThisYear	Specifies the Is Prior This Year filter criteria.
Function

Related API Members

The following properties accept/return ClauseType values:

Library	Related API Members
WinForms Controls	CustomValueEditorArgs.Operation
	ShowValueEditorEventArgs.Operation
WPF Controls	ColumnBase.AutoFilterCriteria
	ExcelColumnFilterSettings.DefaultRulesFilterType
WinUI Controls	ColumnBase.AutoFilterCriteria
ASP.NET Web Forms Controls	FilterControlOperationVisibilityEventArgs.Operation