FunctionOperatorType Enum
Lists functions the Criteria Language supports.
Namespace: DevExpress.Data.Filtering
Assembly: DevExpress.XamarinForms.Core.dll
NuGet Package: DevExpress.XamarinForms.Core
Declaration
[Serializable]
public enum FunctionOperatorType
Members
Name | Description |
---|---|
None
|
The function type is not specified. |
Custom
|
The custom function the ICustomFunctionOperator interface represents. You should register all custom operators the Criteria Language recognizes. Use the CriteriaOperator.RegisterCustomFunction or CriteriaOperator.RegisterCustomFunctions method to do this. |
Iif
|
Returns one of values, depending on which expression evaluates to The function takes 2N+1 arguments (N - the number of logical expressions):
Category: Logical String analogue: |
IsNull
|
Returns the first value if it is not Category: Logical String analogue: |
IsNullOrEmpty
|
Returns Category: Logical String analogue: |
Trim
|
Removes all leading and trailing whitespaces from the specified string. Category: Text String analogue: |
Len
|
Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable. Category: All String analogue: |
Substring
|
Returns a new string that is substring of the one specified. The substring starts at StartIndex and has a specified Length (up to the end by default). Category: Text String analogue: |
Upper
|
Returns the specified string in uppercase. Category: Text String analogue: |
Lower
|
Returns the specified string in lowercase. Category: Text String analogue: |
Concat
|
Returns a string that is the concatenation of the all strings passed as arguments. Category: Text String analogue: |
Ascii
|
Returns the ASCII code of the first character in the specified string expression. Category: Text String analogue: |
Char
|
Returns the character whose code the passed integer value specifies. Category: Text String analogue: |
ToStr
|
Returns a string representation of the specified object. Category: All String analogue: |
Replace
|
Returns a new string that is the first string in which the second string is replaced with the third string.
Category: Text
String analogue: |
Reverse
|
Returns a new string that is the specified string reversed.
Category: Text
String analogue: |
Insert
|
Returns the string that contains the first string with the inserted second string starting with the specified zero-based position. Category: Text String analogue: |
CharIndex
|
Returns the zero-based position of the first string within the second string, beginning from the passed index or zero if it is not specified. Category: Text String analogue: |
Remove
|
Returns a new string in which a specified number of characters (all, by default) in the passed string beginning at a given position, are removed. Category: Text String analogue: |
Abs
|
Returns the absolute value of the numeric expression. Category: Math String analogue: |
Sqr
|
Returns the square root of the specified value. Category: Math String analogue: |
Cos
|
Returns the cosine of the specified value in radians. Category: Math String analogue: |
Sin
|
Returns the sine of the specified value in radians. Category: Math String analogue: |
Atn
|
Returns the angle in radians, whose tangent is the given float expression. Category: Math String analogue: |
Exp
|
Returns the exponential value of the specified value. Category: Math String analogue: |
Log
|
Returns the natural (base e) logarithm of the specified value. Category: Math String analogue: |
Rnd
|
Returns a random number that is greater than or equal to zero and less than one. Category: Math String analogue: |
Tan
|
Returns the tangent of the specified value in radians. Category: Math String analogue: |
Power
|
Returns the specified numeric value raised to the specified power. Category: Math String analogue: |
Sign
|
Returns a value indicating the sign of a number represented by a specified operand. The function returns one of the following values:
Category: Math String analogue: |
Round
|
Rounds the specified value to the nearest integer or to the passed number of decimal places. Category: Math String analogue: |
Ceiling
|
Returns a smallest Category: Math String analogue: |
Floor
|
Returns a largest Category: Math String analogue: |
Max
|
Returns the maximum from specified values. Category: Math String analogue: |
Min
|
Returns the Minimum from specified values. Category: Math String analogue: |
Acos
|
Returns the angle in radians, whose cosine is the given float expression. Category: Math String analogue: |
Asin
|
Returns the angle in radians, whose sine is the given float expression. Category: Math String analogue: |
Atn2
|
Returns the angle in radians, whose tangent is the quotient of two specified numbers. Category: Math String analogue: |
BigMul
|
Returns a Category: Math String analogue: |
Cosh
|
Returns the hyperbolic cosine of the specified value in radians. Category: Math String analogue: |
Log10
|
Returns the common (base 10) logarithm of the specified value. Category: Math String analogue: |
Sinh
|
Returns the hyperbolic sine of the specified value in radians. Category: Math String analogue: |
Tanh
|
Returns the hyperbolic tangent of the specified value in radians. Category: Math String analogue: |
PadLeft
|
Returns the left-aligned string, filled with the specified character (whitespace by default) up to the specified string length. Category: Text String analogue: |
PadRight
|
Returns the right-aligned string, filled with the specified character (whitespace by default) up to the specified string length. Category: Text String analogue: |
StartsWith
|
Returns Category: Text String analogue: |
EndsWith
|
Returns Category: Text String analogue: |
Contains
|
Returns Category: Text String analogue: |
ToInt
|
Returns the Category: Math String analogue: |
ToLong
|
Returns the Category: Math String analogue: |
ToFloat
|
Returns the Category: Math String analogue: |
ToDouble
|
Returns the Category: Math String analogue: |
ToDecimal
|
Returns the Category: Math String analogue: |
LocalDateTimeThisYear
|
Returns the date-time value that corresponds to the first day of this year. Category: DateTime String analogue: |
LocalDateTimeThisMonth
|
Returns the date-time value that corresponds to the first day of this month. Category: DateTime String analogue: |
LocalDateTimeLastWeek
|
Returns the date-time value that corresponds to the first day of the previous week. Category: DateTime String analogue: |
LocalDateTimeThisWeek
|
Returns the date-time value that corresponds to the first day of this week. Category: DateTime String analogue: |
LocalDateTimeYesterday
|
Returns the date-time value that corresponds to the yesterday midnight. Category: DateTime String analogue: |
LocalDateTimeToday
|
Returns the date-time value that corresponds to the current day’s midnight. Category: DateTime String analogue: |
LocalDateTimeNow
|
Returns the date-time value that corresponds to the local date and time. Category: DateTime String analogue: |
LocalDateTimeTomorrow
|
Returns the date-time value that corresponds to the tomorrow midnight. Category: DateTime String analogue: |
LocalDateTimeDayAfterTomorrow
|
Returns the date-time value that corresponds to the day after tomorrow. Category: DateTime String analogue: |
LocalDateTimeNextWeek
|
Returns the date-time value that corresponds to the first day of the next week. Category: DateTime String analogue: |
LocalDateTimeTwoWeeksAway
|
Returns the date-time value that corresponds to the first day of the week after the next. Category: DateTime String analogue: |
LocalDateTimeNextMonth
|
Returns the date-time value that corresponds to the first day of the next month. Category: DateTime String analogue: |
LocalDateTimeNextYear
|
Returns the date-time value that corresponds to the first day of the next year. Category: DateTime String analogue: |
IsOutlookIntervalBeyondThisYear
|
Returns whether the specified date is beyond this year (date >= FirstDayOfNextYear). Category: DateTime String analogue: |
IsOutlookIntervalLaterThisYear
|
Returns whether the specified date is later in this year (FirstDayOfNextMonth <= date < FirstDayOfNextYear). Category: DateTime String analogue: |
IsOutlookIntervalLaterThisMonth
|
Returns whether the specified date is later in this month (LastDayOfNextWeek < date < FirstDayOfNextMonth). Category: DateTime String analogue: |
IsOutlookIntervalNextWeek
|
Returns whether the specified date is in next week (FirstDayOfNextWeek <= date < LastDayOfNextWeek). Category: DateTime String analogue: |
IsOutlookIntervalLaterThisWeek
|
Returns whether the specified date is later in this week (DayAfterTomorrow < date < FirstDayOfNextWeek). Category: DateTime String analogue: |
IsOutlookIntervalTomorrow
|
Returns whether the specified date is tomorrow. Category: DateTime String analogue: |
IsOutlookIntervalToday
|
Returns whether the specified date is today. Category: DateTime String analogue: |
IsOutlookIntervalYesterday
|
Returns whether the specified date is tomorrow. Category: DateTime String analogue: |
IsOutlookIntervalEarlierThisWeek
|
Returns whether the specified date is earlier in this week (FirstDayOfThisWeek <= date < Yesterday). Category: DateTime String analogue: |
IsOutlookIntervalLastWeek
|
Returns whether the specified date is in last week (FirstDayOfLastWeek <= date < FirstDayOfThisWeek). Category: DateTime String analogue: |
IsOutlookIntervalEarlierThisMonth
|
Returns whether the specified date is earlier in this month (FirstDayOfThisMonth <= date <= FirstDayOfLastWeek). Category: DateTime String analogue: |
IsOutlookIntervalEarlierThisYear
|
Returns whether the specified date is earlier in this year (FirstDayOfThisYear <= date < FirstDayOfThisMonth). Category: DateTime String analogue: |
IsOutlookIntervalPriorThisYear
|
Returns whether the specified date is before this year (date < FirstDayOfThisYear). Category: DateTime String analogue: |
IsThisWeek
|
Returns whether the specified date is in the current week. Category: DateTime String analogue: |
IsThisMonth
|
Returns whether the specified date is in the current month. Category: DateTime String analogue: |
IsThisYear
|
Returns whether the specified date is in the current year. Category: DateTime String analogue: |
DateDiffTick
|
Returns the count of tick boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffSecond
|
Returns the count of second boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffMilliSecond
|
Returns the count of millisecond boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffMinute
|
Returns the count of minute boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffHour
|
Returns the count of hour boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffDay
|
Returns the count of day boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffMonth
|
Returns the count of month boundaries between two specified dates. Category: DateTime String analogue: |
DateDiffYear
|
Returns the count of year boundaries between two specified dates. Category: DateTime String analogue: |
GetDate
|
Returns a date from the specified DateTime expression. Category: DateTime String analogue: |
GetMilliSecond
|
Returns a millisecond from the specified DateTime expression. Category: DateTime String analogue: |
GetSecond
|
Returns a second from the specified DateTime expression. Category: DateTime String analogue: |
GetMinute
|
Returns a minute from the specified DateTime expression. Category: DateTime String analogue: |
GetHour
|
Returns an hour from the specified DateTime expression. Category: DateTime String analogue: |
GetDay
|
Returns a day from the specified DateTime expression. Category: DateTime String analogue: |
GetMonth
|
Returns a month from the specified DateTime expression. Category: DateTime String analogue: |
GetYear
|
Returns a year from the specified DateTime expression. Category: DateTime String analogue: |
GetDayOfWeek
|
Returns a day of the week from the specified DateTime expression. Category: DateTime String analogue: |
GetDayOfYear
|
Returns a day of the year from the specified DateTime expression. Category: DateTime String analogue: |
GetTimeOfDay
|
Returns a time of the day from the specified DateTime expression. Category: DateTime String analogue: |
Now
|
Returns the current system date and time. Category: DateTime String analogue: |
UtcNow
|
Returns the current system date and time, expressed as Coordinated Universal Time (UTC). Category: DateTime String analogue: |
Today
|
Returns the current system date. Regardless of the actual time, this function returns midnight of the current date. Category: DateTime String analogue: |
AddTimeSpan
|
Returns a new DateTime value that adds the specified time span to the given value. Category: DateTime String analogue: |
AddTicks
|
Returns a new DateTime value that adds the specified number of ticks to the given value. Category: DateTime String analogue: |
AddMilliSeconds
|
Returns a new DateTime value that adds the specified number of milliseconds to the given value. Category: DateTime String analogue: |
AddSeconds
|
Returns a new DateTime value that adds the specified number of seconds to the given value. Category: DateTime String analogue: |
AddMinutes
|
Returns a new DateTime value that adds the specified number of minutes to the given value. Category: DateTime String analogue: |
AddHours
|
Returns a new DateTime value that adds the specified number of hours to the given value. Category: DateTime String analogue: |
AddDays
|
Returns a new DateTime value that adds the specified number of days to the given value. Category: DateTime String analogue: |
AddMonths
|
Returns a new DateTime value that adds the specified number of months to the given value. Category: DateTime String analogue: |
AddYears
|
Returns a new DateTime value that adds the specified number of years to the given value. Category: DateTime String analogue: |
Remarks
The FunctionOperator.OperatorType field uses types this enumeration contains.
All values contain a string equivalent that produces the same function when you pass it to the CriteriaOperator.Parse method