[Expand]General Information
[Expand]WinForms Controls
[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]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress Data Library
 [Expand]DevExpress Pivot Grid Core Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Collapse]DevExpress.Data.Filtering
    Aggregate Enumeration
   [Expand]AggregateOperand Class
   [Expand]BaseNodeEventArgs Class
   [Expand]BetweenOperator Class
   [Expand]BinaryOperator Class
    BinaryOperatorType Enumeration
   [Expand]ConstantValue Class
   [Expand]ContainsOperator Class
   [Expand]CriteriaOperator Class
   [Expand]CriteriaOperatorCollection Class
   [Expand]EnumProcessingHelper Class
    FilterCondition Enumeration
    FindPanelParserKind Enumeration
    FunctionCategory Enumeration
   [Expand]FunctionOperator Class
    FunctionOperatorType Enumeration
   [Expand]GroupOperator Class
    GroupOperatorType Enumeration
   [Expand]IClientCriteriaVisitor Interface
   [Expand]ICriteriaVisitor Interface
   [Expand]ICustomFunctionOperator Interface
   [Expand]ICustomFunctionOperatorBrowsable Interface
   [Expand]ICustomFunctionOperatorCompileable Interface
   [Expand]ICustomFunctionOperatorCompileableWithCaseSensitivity Interface
   [Expand]ICustomFunctionOperatorConvertibleToExpression Interface
   [Expand]ICustomFunctionOperatorEvaluatableWithCaseSensitivity Interface
   [Expand]ICustomFunctionOperatorFormattable Interface
   [Expand]InOperator Class
   [Expand]JoinOperand Class
   [Expand]NotOperator Class
   [Expand]NullOperator Class
   [Expand]OperandParameter Class
   [Expand]OperandProperty Class
   [Expand]OperandValue Class
   [Expand]UnaryOperator Class
    UnaryOperatorType Enumeration
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.DataFederation
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Json
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.Gantt
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.Printing.ExportHelpers
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Security.Resources
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.Utils.Svg
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Native
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.Caching
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Rules
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

FunctionOperatorType Enumeration

Enumerates function types that can be used by the FunctionOperator operators.

Namespace:DevExpress.Data.Filtering
Assembly:DevExpress.Data.v19.1.dll

Expanded Public Members

Show: Inherited
  Name Description
Public field Abs

Returns the absolute value of a specified numeric operand.

If a specified operand is not numeric, the System.NotSupportedException is thrown.

To create the Abs operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Abs(Field1)").

Public field Acos

Returns the angle (in radians) whose cosine is a specified numeric operand.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Acos operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Acos(Field1)").

Public field AddDays

Returns a System.DateTime object representing the date that is a specified number of days from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in days) from the original date. This number can be negative or positive. Its decimal part is part of a day.

To create the AddDays operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddDays(Field1, Field2)").

Public field AddHours

Returns a System.DateTime object representing the date that is a specified number of hours from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in hours) from the original date. This number can be negative or positive. Its decimal part is part of an hour.

To create the AddHours operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddHours(Field1, Field2)").

Public field AddMilliSeconds

Returns a System.DateTime object representing the date that is a specified number of milliseconds from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in milliseconds) from the original date. This number can be negative or positive. Its decimal part is part of a millisecond.

To create the AddMilliSeconds operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddMilliseconds(Field1, Field2)").

Public field AddMinutes

Returns a System.DateTime object representing the date that is a specified number of minutes from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in minutes) from the original date. This number can be negative or positive. Its decimal part is part of a minute.

To create the AddMinutes operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddMinutes(Field1, Field2)").

Public field AddMonths

Returns a System.DateTime object representing the date that is a specified number of months from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in months) from the original date. This number can be negative or positive.

To create the AddMonths operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddMonths(Field1, Field2)").

Public field AddSeconds

Returns a System.DateTime object representing the date that is a specified number of seconds from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in seconds) from the original date. This number can be negative or positive. Its decimal part is part of a second.

To create the AddSeconds operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddSeconds(Field1, Field2)").

Public field AddTicks

Returns a System.DateTime object representing the date that is a specified number of ticks from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in 100-nanosecond ticks) from the original date. This number can be negative or positive.

To create the AddTicks operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddTicks(Field1, Field2)").

Public field AddTimeSpan

Returns a System.DateTime object representing the date that is a specified time period from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - a System.TimeSpan object representing the time period from the original date.

To create the AddTimeSpan operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddTimeSpan(Field1, Field2)").

Public field AddYears

Returns a System.DateTime object representing the date that is a specified number of years from a specific date.

The operands should be defined as follows:

1 - a System.DateTime object representing the original date;

2 - the time period (in years) from the original date. This number can be negative or positive.

To create the AddYears operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("AddYears(Field1, Field2)").

Public field Ascii

Returns the ASCII code of the first character in a specified string operand.

If a specified operand represents an empty string, null is returned.

To create the Ascii operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Ascii(Field1)").

Public field Asin

Returns the angle (in radians) whose sine is a specified numeric operand.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Asin operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Asin(Field1)").

Public field Atn

Returns the angle (in radians) whose tangent is a specified numeric operand.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Atn operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Atn(Field1)").

Public field Atn2

Returns the angle (in radians) whose tangent is the quotient of two specified numeric operands.

The operator requires two operands representing the Cartesian coordinates (x, y) of a point:

1 - the y coordinate;

2 - the x coordinate.

If specified operands cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Atn2 operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Atn2(y, x)").

Public field BigMul

Calculates the product of two specified numeric operands.

The operator requires two operands representing the integer values to be multiplied.

If the specified operands do not represent integer values, the System.NotSupportedException is thrown.

To create the BigMul operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("BigMul(Field1, Field2)").

Public field Ceiling

Returns the smallest integer greater than or equal to a specified numeric operand. The rounding provided by this operator is called rounding toward positive infinity.

If a specified operand is not numeric, the System.NotSupportedException is thrown.

To create the Ceiling operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Ceiling(Field1)").

Public field Char

Converts a specified numeric operand to a Unicode character.

If a specified operand cannot be converted to a decimal or integer number, the System.NotSupportedException is thrown.

To create the Char operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Char(Field1)").

Public field CharIndex

Returns the index of the first occurrence of a specified substring in a specified string.

The operands should be defined as follows:

1 - a substring to search for;

2 - a string to be searched in;

3 - (optional) an integer that specifies the zero-based index at which the search starts. If this operand is not specified, the search begins from the start of the string;

4 - (optional) an integer that specifies the number of characters to examine, starting from the specified position. If this operand is not specified, the search continues until the end of the string.

This function performs a word (case-sensitive and culture-sensitive) search using the current culture. If a specified substring is found, the function returns its index. Otherwise, -1 is returned.

To create the CharIndex operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("CharIndex(Field1, Field2)"), CriteriaOperator.Parse("CharIndex(Field1, Field2, Field3)"), or CriteriaOperator.Parse("CharIndex(Field1, Field2, Field3, Field4)").

Public field Concat Concatenates one or more strings.
Public field Contains

Returns True if one string occurs within another string; otherwise, False is returned.

This function requires two string operands:

1 - a string to be searched;

2 - a substring to search.

To create the Contains operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Contains(String, SubString)");

Public field Cos

Returns the cosine of a specified numeric operand representing an angle, measured in radians.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Cos operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Cos(Field1)").

Public field Cosh

Returns the hyperbolic cosine of a specified numeric operand representing an angle, measured in radians.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Cosh operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Cosh(Field1)").

Public field Custom

Identifies a custom operation. This operation is executed on the client side if its operands represent constants. A custom operation is executed on the server side only if its operands cannot be evaluated locally. To learn how to implement custom operators, refer to the How to: Implement a Custom Criteria Language Function Operator topic.

The eXpress Persistent Objects framework provides two custom function operators - DevExpress.Xpo.Metadata.IsExactTypeFunction and DevExpress.Xpo.Metadata.IsInstanceOfTypeFunction.

Public field CustomNonDeterministic

Identifies a custom nondeterministic operation.

Unlike a standard custom operation, a custom nondeterministic operation is always executed on the server side, regardless of whether its operands are constants.

Refer to the How to: Implement a Custom Criteria Language Function Operator topic, to learn how to implement custom operators.

Public field DateDiffDay

Returns the count of day boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffDay operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffDay(StartDate, EndDate)").

Public field DateDiffHour

Returns the count of hour boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffHour operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffHour(StartDate, EndDate)").

Public field DateDiffMilliSecond

Returns the count of millisecond boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffMilliSecond operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffMilliSecond(StartDate, EndDate)").

Public field DateDiffMinute

Returns the count of minute boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffMinute operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffMinute(StartDate, EndDate)").

Public field DateDiffMonth

Returns the count of month boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffMonth operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffMonth(StartDate, EndDate)").

Public field DateDiffSecond

Returns the count of second boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffSecond operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffSecond(StartDate, EndDate)").

Public field DateDiffTick

Returns the count of tick boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffTick operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffTick(StartDate, EndDate)").

Public field DateDiffYear

Returns the count of year boundaries crossed between the specified starting date and ending date.

The operands should be defined as follows:

1 - a System.DateTime object representing the starting date;

2 - a System.DateTime object representing the ending date.

To create the DateDiffYear operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("DateDiffYear(StartDate, EndDate)").

Public field EndsWith

Returns True if the end of one string matches another string; otherwise, False is returned.

This function requires two string operands:

1 - a string to be searched;

2 - a substring to search at the end of the first string.

To create the EndsWith operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("EndsWith(String, SubString)");

Public field Exp

Returns the number e raised to the power specified by a numeric operand.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

Exp reverses Log. Use the Power operand to calculate powers of other bases.

To create the Exp operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Exp(Field1)").

Public field Floor

Returns the largest integer less than or equal to a specified numeric operand. The rounding provided by this operator is called rounding toward negative infinity.

If a specified operand is not numeric, the System.NotSupportedException is thrown.

To create the Floor operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Floor(Field1)").

Public field GetDate

Returns the date part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value represents a System.DateTime object with the same date part, and the time part set to 00:00:00.

To create the GetDate operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetDate(Field1)").

Public field GetDay

Gets the day part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 1 and 31.

To create the GetDay operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetDay(Field1)").

Public field GetDayOfWeek

Gets a specified date's day of the week.

This operator requires an operand of the System.DateTime type.

The return value represents a System.Int32 equivalent of a System.DayOfWeek enumerated constant representing a day of the week.

To create the GetDayOfWeek operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetDayOfWeek(Field1)").

Public field GetDayOfYear

Gets a specified date's day of the year.

This operator requires an operand of the System.DateTime type.

The return value ranges between 1 and 366.

To create the GetDayOfYear operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetDayOfYear(Field1)").

Public field GetHour

Gets the hour part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 0 and 23.

To create the GetHour operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetHour(Field1)").

Public field GetMilliSecond

Gets the milliseconds part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 0 and 999.

To create the GetMilliSecond operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetMilliSecond(Field1)").

Public field GetMinute

Gets the minute part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 0 and 59.

To create the GetMinute operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetMinute(Field1)").

Public field GetMonth

Gets the month part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 1 and 12.

To create the GetMonth operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetMonth(Field1)").

Public field GetSecond

Gets the seconds part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 0 and 59.

To create the GetSecond operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetSecond(Field1)").

Public field GetTimeOfDay

Gets the time part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value represents a System.Int64 object that is equal to the number of 100-nanosecond ticks that have elapsed since midnight.

To create the GetTimeOfDay operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("GetTimeOfDay(Field1)").

Public field GetYear

Gets the year part of a specified date.

This operator requires an operand of the System.DateTime type.

The return value ranges between 1 and 9999.

To create the GetYear operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("GetYear(Field1)").

Public field Iif

Returns one of several specified values depending upon the values of logical expressions. The function can take 2N+1 arguments (N - the number of specified logical expressions):

  • Each odd argument specifies a logical expression;
  • Each even argument specifies the value that is returned if the previous expression evaluates to true.

Examples:
Iif(Name = 'Bob', 1, 0)
Iif(Name = 'Bob', 1, Name = 'Dan', 2, Name = 'Sam', 3, 0)

Public field Insert

Inserts a specified string at a certain position within another.

The operands should be defined as follows:

1 - a string in which the insertion is to be performed;

2 - an integer that specifies the zero-based index position of the insertion;

3 - a string to insert.

To create the Insert operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Insert(Field1, Field2, Field3)").

Public field IsApril Returns True if the specified date falls within April.
Public field IsAugust Returns True if the specified date falls within August.
Public field IsDecember Returns True if the specified date falls within December.
Public field IsFebruary Returns True if the specified date falls within February.
Public field IsJanuary Returns True if the specified date falls within January.
Public field IsJuly Returns True if the specified date falls within July.
Public field IsJune Returns True if the specified date falls within June.
Public field IsLastMonth Returns True if the specified date falls within the previous month.
Public field IsLastYear Returns True if the specified date falls within the previous year.
Public field IsMarch Returns True if the specified date falls within March.
Public field IsMay Returns True if the specified date falls within May.
Public field IsNextMonth Returns True if the specified date falls within the next month.
Public field IsNextYear Returns True if the specified date falls within the next year.
Public field IsNovember Returns True if the specified date falls within November.
Public field IsNull

Compares the first operand with the NULL value.

This function requires one or two operands of the CriteriaOperator class. The value returned depends upon the number of arguments.

If a single operand is passed, the function returns true if the operand is null, otherwise, false is returned.

If two operands are passed, the function returns the second operand if the first operand is null, otherwise, the first operand is returned.

To create the IsNull operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("IsNull(Field1)") or CriteriaOperator.Parse("IsNull(Field1AndTrueResult, FalseResult)").

Public field IsNullOrEmpty

Indicates whether a specified operand is a null reference or an empty string.

The function returns true if a specified operand is null or an empty string, otherwise, false is returned.

To create the IsNullOrEmpty operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("IsNullOrEmpty(Field1)").

Public field IsOctober Returns True if the specified date falls within October.
Public field IsOutlookIntervalBeyondThisYear

The Boolean Is Beyond This Year operator for date/time values. Requires one argument.

The operator is defined as follows: date >= First Day of Next Year

Public field IsOutlookIntervalEarlierThisMonth

The Boolean Is Earlier This Month operator for date/time values. Requires one argument.

The operator is defined as follows: First Day of This Month <= date < First Day of Last Week

Public field IsOutlookIntervalEarlierThisWeek

The Boolean Is Earlier This Week operator for date/time values. Requires one argument.

The operator is defined as follows: First Day of This Week <= date < Yesterday

Public field IsOutlookIntervalEarlierThisYear

The Boolean Is Earlier This Year operator for date/time values. Requires one argument.

The operator is defined as follows: First Day of This Year <= date < First Day of This Month

Public field IsOutlookIntervalLastWeek

The Boolean Is Last Week operator for date/time values. Requires one argument.

The operator is defined as follows: First Day of Last Week <= date < First Day of This Week

Public field IsOutlookIntervalLaterThisMonth

The Boolean Is Later This Month operator for date/time values. Requires one argument.

The operator is defined as follows: Last Day of Next Week < date < First Day of Next Month

Public field IsOutlookIntervalLaterThisWeek

The Boolean Is Later This Week operator for date/time values. Requires one argument.

The operator is defined as follows: Day After Tomorrow <= date < First Day of Next Week

Public field IsOutlookIntervalLaterThisYear

The Boolean Is Later This Year operator for date/time values. Requires one argument.

The operator is defined as follows: First Day of Next Month <= date < First Day of Next Year

Public field IsOutlookIntervalNextWeek

The Boolean Is Next Week operator for date/time values. Requires one argument.

The operator is defined as follows: First Day of Next Week <= date <= Last Day of Next Week

Public field IsOutlookIntervalPriorThisYear

The Boolean Is Prior This Year operator for date/time values. Requires one argument.

The operator is defined as follows: date < First Day of This Year

Public field IsOutlookIntervalToday The Boolean Is Today operator for date/time values. Requires one argument.
Public field IsOutlookIntervalTomorrow The Boolean Is Tomorrow operator for date/time values. Requires one argument.
Public field IsOutlookIntervalYesterday The Boolean Is Yesterday operator for date/time values. Requires one argument.
Public field IsSameDay Returns True if the specified date/time values fall within the same day.
Public field IsSeptember Returns True if the specified date falls within September.
Public field IsThisMonth

Returns True if the specified date falls within the current month.

To create the IsThisMonth operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("IsThisMonth(StartDate)").

Public field IsThisWeek

Returns True if the specified date falls within the current week.

To create the IsThisWeek operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("IsThisWeek(StartDate)").

Public field IsThisYear

Returns True if the specified date falls within the current year.

To create the IsThisYear operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("IsThisYear(StartDate)").

Public field IsYearToDate Returns True if the specified date falls within the year-to-date period. This period starts from the first day of the current year and continues up to the current date (including this current date).
Public field Len

Returns the length of the string specified by an operand.

The operand should be an object of the CriteriaOperator type.

To create the Len operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Len(Field1)");

Public field LocalDateTimeDayAfterTomorrow Returns the DateTime value corresponding to the day after Tomorrow.
Public field LocalDateTimeLastMonth Returns the DateTime value corresponding to the first day of the previous month.
Public field LocalDateTimeLastWeek Returns the DateTime value corresponding to the first day of the previous week.
Public field LocalDateTimeLastYear Returns the DateTime value corresponding to the first day of the previous year.
Public field LocalDateTimeNextMonth Returns the DateTime value corresponding to the first day of next month.
Public field LocalDateTimeNextWeek Returns the DateTime value corresponding to the first day of the following week.
Public field LocalDateTimeNextYear Returns the DateTime value corresponding to the first day of the following year.
Public field LocalDateTimeNow Returns the DateTime value corresponding to the current moment in time.
Public field LocalDateTimeThisMonth Returns the DateTime value corresponding to the first day of the current month.
Public field LocalDateTimeThisWeek Returns the DateTime value corresponding to the first day of the current week.
Public field LocalDateTimeThisYear Returns the DateTime value corresponding to the first day of the current year.
Public field LocalDateTimeToday Returns the DateTime value corresponding to Today.
Public field LocalDateTimeTomorrow Returns the DateTime value corresponding to Tomorrow.
Public field LocalDateTimeTwoMonthsAway Returns the DateTime value corresponding to the first day of the month after next.
Public field LocalDateTimeTwoWeeksAway Returns the DateTime value corresponding to the first day of the week after next.
Public field LocalDateTimeTwoYearsAway Returns the DateTime value corresponding to the first day of the year after next.
Public field LocalDateTimeYearBeforeToday Returns the DateTime value corresponding to the day one year ago.
Public field LocalDateTimeYesterday Returns the DateTime value corresponding to Yesterday.
Public field Log

Returns the logarithm of a specified numeric operand. The return value depends upon the number of operands.

If one operand is passed, the natural (base e) logarithm of a specified operand is returned.

If two operands are passed, the logarithm of a specified operand in a specified base is returned. The operands should be defined as follows:

1 - a number whose logarithm is to be calculated;

2 - the base of the logarithm.

If specified operands cannot be converted to System.Double, the System.NotSupportedException is thrown.

Log reverses Exp. To calculate the base 10 logarithm, use Log10.

To create the Log operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Log(Field1)") or CriteriaOperator.Parse("Log(Field1, Field2)").

Public field Log10

Returns the base 10 logarithm of a specified numeric operand.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

Log10 reverses Power. Use the Log operand to calculate the logarithm of other bases.

To create the Log10 operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Log10(Field1)").

Public field Lower

Converts all characters in a string operand to lowercase.

The operand should be an object of the CriteriaOperator type.

To create the Lower operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Lower(Field1)");

Public field Max

Returns the larger of two numeric values.

The operands should be defined as follows:

1 - a numeric value A;

2 - a numeric value B;

To create the Max operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Max(ValueA, ValueB)").

Public field Min

Returns the smaller of two numeric values.

The operands should be defined as follows:

1 - a numeric value A;

2 - a numeric value B;

To create the Min operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Min(ValueA, ValueB)").

Public field None The function type is not specified.
Public field Now

Returns a System.DateTime object representing the system's current date and time.

To create the Now operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Now()").

Public field PadLeft

Pads a string with spaces or a specified Unicode character on the left for a specified total length.

The operands should be defined as follows:

1 - a string to be padded;

2 - the total number of characters in the resulting string, including padding characters;

3 - (optional) a Unicode padding character. If not specified, the space character is used for padding. If a string is passed as this operand, its first character is used for padding.

To create the PadLeft operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("PadLeft(Field1, Field2)") or CriteriaOperator.Parse("PadLeft(Field1, Field2, Field3)").

Public field PadRight

Pads a string with spaces or a specified Unicode character on the right for a specified total length.

The operands should be defined as follows:

1 - a string to be padded;

2 - the total number of characters in the resulting string, including padding characters;

3 - (optional) a Unicode padding character. If not specified, the space character is used for padding. If a string is passed as this operand, its first character is used for padding.

To create the PadRight operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("PadRight(Field1, Field2)") or CriteriaOperator.Parse("PadRight(Field1, Field2, Field3)").

Public field Power

Returns a specified numeric operand raised to a specific power.

The Power operator requires two operands:

1 - a number to be raised to a power;

2 - a power.

If specified operands cannot be converted to System.Double, the System.NotSupportedException is thrown.

Power reverses Log or Log10. Use the Exp operand to calculate powers of the number e.

To create the Power operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Power(Field1, Field2)").

Public field Remove

Removes all, or a certain number of characters from a specified string, starting at a specified position.

The operands should be defined as follows:

1 - a string to be shrunk;

2 - an integer that specifies the zero-based index at which character removal starts;

3 - (optional) an integer that specifies the number of characters to remove, starting at the specified position. If this operand is not specified, all characters between the starting position and the end of the string are removed.

To create the Remove operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Remove(Field1, Field2)") or CriteriaOperator.Parse("Remove(Field1, Field2, Field3)").

Public field Replace

Replaces all occurrences of a certain string in a specified string, with another.

The operands should be defined as follows:

1 - a string in which replacements are to be performed;

2 - a string to be replaced;

3 - a string to replace all occurrences found.

To create the Replace operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Replace(Field1, Field2, Field3)").

Public field Reverse

Reverses the order of characters within a specified string.

To create the Reverse operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Reverse(Field1)").

Public field Rnd

Returns a random number greater than or equal to 0.0, and less than 1.0.

To create the Rnd operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Rnd()").

Public field Round

Rounds a specified numeric operand to the nearest integer or to a specified number of decimal places. The rounding provided by this operator is called rounding to nearest or banker's rounding.

The operands should be defined as follows:

1 - a value to round;

2 - (optional) a value specifying the number of decimal places to round to. 0 indicates that the first operand is rounded to the nearest integer.

To create the Round operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Round(Field1)") or CriteriaOperator.Parse("Round(Field1, Field2)").

Public field Sign

Returns a value indicating the sign of a number represented by a specified operand. The function returns one of the following values:

1, for positive numbers;

-1, for negative numbers;

0, if the number is equal to zero.

If a specified operand is not numeric, System.NotSupportedException is thrown.

To create the Sign operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Sign(Field1)").

Public field Sin

Returns the sine of a specified numeric operand representing an angle, measured in radians.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Sin operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Sin(Field1)").

Public field Sinh

Returns the hyperbolic sine of a specified numeric operand representing an angle, measured in radians.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Sinh operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Sinh(Field1)").

Public field Sqr

Returns the square root of a specified numeric operand.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Sqr operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Sqr(Field1)").

Public field StartsWith

Returns True if the beginning of one string matches another string; otherwise, False is returned.

This function requires two string operands:

1 - a string to be searched;

2 - a substring to search at the beginning of the first string.

To create the StartsWith operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("StartsWith(String, SubString)");

Public field Substring

Returns a substring extracted from the specified string. This function requires two or three operands of the CriteriaOperator class.

If two operands are passed the substring will be extracted from the beginning of the original string. The operands should be defined as follows:

1 - an original string;

2 - an integer that specifies the zero-based index at which the substring to return begins.

If three operands are passed a substring can be subtracted starting from any position in the original string. The operands should be defined as follows:

1 - an original string;

2 - an integer that specifies the zero-based index at which the substring to return begins;

3 - an integer that specifies the length of the substring.

To create a Substring operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Substring(Field1, 1, 3)");

Public field Tan

Returns the tangent of a specified numeric operand representing an angle, measured in radians.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Tan operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Tan(Field1)").

Public field Tanh

Returns the hyperbolic tangent of a specified numeric operand representing an angle, measured in radians.

If a specified operand cannot be converted to System.Double, the System.NotSupportedException is thrown.

To create the Tanh operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Tanh(Field1)").

Public field Today

Returns a System.DateTime object representing the system's current date. The object's time part is set to 00:00:00.

To create the Today operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Today()").

Public field ToDecimal

Converts a numeric operand to a fixed-point (exact-value) representation.

To create the ToDecimal operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("ToDecimal(Field2)").

Note that the resulting value may vary, based on the database system used as the backend.

Public field ToDouble

Converts a numeric operand to a double-precision floating-point (approximate-value) representation.

To create the ToDouble operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("ToDouble(Field2)").

Note that the resulting value may vary, based on the database system used as the backend.

Public field ToFloat

Converts a numeric operand to a floating-point (approximate-value) representation.

To create the ToFloat operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("ToFloat(Field2)").

Note that the resulting value may vary, based on the database system used as the backend.

Public field ToInt

Converts a numeric operand to an integer representation.

To create the ToInt operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("ToInt(Field2)").

Note that the resulting value may vary, based on the database system used as the backend.

Public field ToLong

Converts a numeric operand to a long integer representation.

To create the ToLong operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("ToLong(Field2)").

Note that the resulting value may vary, based on the database system used as the backend.

Public field ToStr

Returns a string representation of a specified numeric operand.

If a specified operand is not numeric, the System.NotSupportedException is thrown.

To create the ToStr operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("ToStr(Field1)").

Note that the resulting string may vary, based on the format settings of the database system used as the backend.

Public field Trim

Returns a string containing a copy of a specified string with no leading nor trailing spaces. This function requires a single operand of the CriteriaOperator class that refers to the original string.

To create the Trim operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse("Trim(Field2)");

Public field Upper

Converts all characters in a string operand to uppercase.

The operand should be an object of the CriteriaOperator type.

To create the Upper operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("Upper(Field1)");

Public field UtcNow

Returns a System.DateTime object representing the current Coordinated Universal Time (UTC) date and time.

To create the UtcNow operator using the CriteriaOperator.Parse method, use the following syntax: CriteriaOperator.Parse("UtcNow()").

Top

Expanded Remarks

This enumeration contains function types supported by the FunctionOperator operators.

It's also possible to use the CriteriaOperator.Parse method to create a CriteriaOperator operator for a specific expression.

Note

There are DevExpress products that extend and/or override this function set. The following table lists the articles that explain how to use functions in these products.

Product Article
Reporting Expression Constants, Operators, and Functions
Dashboard Expression Constants, Operators, and Functions
Pivot Grid Pivot Grid Expression Syntax
eXpressApp Framework Function Criteria Operators

Expanded Example

The following example shows how to use the IIF function operator to construct filter criteria. The criteria is then used to select appropriate records from storage using an DevExpress.Xpo.XPCollection. The criteria that are implemented are defined by the following expression: IIF(Field1 == 100, Field1, Field2) > 1000. Firstly the IIF(...) subexpression is evaluated. The result is then compared with 1000. Objects are selected by the criteria if the result of the IIF(...) function is greater than 1000 for them.

This example shows two equivalent ways to set up the filter criteria:

You can see that the second approach is easier and more human readable

Note

The CriteriaOperator.Parse method analyzes the string passed as a parameter, and then creates an equivalent tree of CriteriaOperator operators for it.

Expanded See Also

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