All functions listed alphabetically.
All Function |
Description |
Returns the absolute value of a numeric expression. |
|
The AddDays function adds a specified number of days to a DateTime value. |
|
The AddHours function adds a specified number of hours to a DateTime value. |
|
The AddMilliseconds function adds a specified number of milliseconds to a DateTime value. |
|
The AddMinutes function adds a specified number of minutes to a DateTime value. |
|
The AddMonths function adds a specified number of months to a DateTime value. |
|
The AddSeconds function adds a specified number of seconds to a DateTime value. |
|
The AddWeekdays function adds a specified number of weekdays to a DateTime value. |
|
The AddYears function adds a specified number of years to a DateTime value. |
|
The AllAreFalse function returns true if all of the provided conditions is false. Otherwise false. |
|
Returns true if all of the provided conditions are true. Otherwise false. |
|
The AnyAreFalse function returns true if any of the provided conditions is false. Otherwise false. |
|
Returns true if any of the provided conditions are true. Otherwise false. |
|
Returns the average of a specified field or expression across a collection. |
|
Returns the average of a specified field or expression across a collection. |
|
Returns the number rounded to the number of decimal places using the rules of bankers rounding. |
|
The BuildDate function returns a date from a specified year, month, and day. |
|
Returns the character associated with the specified character code. |
|
The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression. |
|
Generates a string concatenation of two or more expressions. |
|
Generates a string concatenation of two or more expressions. |
|
Determines if a text string or expression contains another text string or expression. |
|
The Count function returns the number of members in a collection. |
|
Returns the value of a field within the context of current expression. |
|
Returns the value of a field within the context of current expression. |
|
Returns the day of the month for a given Date or DateTime. |
|
The DayDiff function returns the number of days between two Date values. |
|
Returns the day of the week with 0 = Sunday and 6 = Saturday. |
|
Returns the day of the year, 1 = 1/1 and 365(366) = 12/31. |
|
The DaysInMonth function returns the number of days in the month. |
|
Returns the number of days in the year. |
|
Divides the value of one numeric expression by another. |
|
Determines if a text string or expression ends with another text string or expression. |
|
Returns true if two expressions are equal. |
|
The EscapeJson function replaces invalid JSON characters (backspace, form feed, newline, carriage return, tab, double quote, and backslash) in a string with their valid equivalent. |
|
The EscapeXml function replaces invalid XML characters (ampersand, less than, greater than, quote, and apostrophe) in a string with their valid XML equivalent. |
|
Returns the value of evaluating the specified value as an expression. |
|
The Exp function returns e raised to a given power. |
|
The Format function formats a numeric or date expression. |
|
Returns the end-of-period future value for a series of payments given the interest rate, number of periods, payment amount, and initial principal |
|
Returns the attribute value for an element as specified by the engine attribute for it. |
|
Returns the default value of the element. |
|
Returns the element id of the element. |
|
Returns the EntitiyID for the element. |
|
Returns the name of the entity. |
|
Gets specified value list by field name. |
|
The GetFirst function returns the first collection member that satisfies a given filter expression. |
|
Returns the specified field value of first member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified. |
|
Returns the current index of a collection member in its parent collection. If it exists in multiple collections, only its index in the first authored collection is returned. |
|
The GetLast function returns the last collection member that satisfies a given filter expression. |
|
Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified. |
|
Returns a datetime value having Local kind. |
|
Returns the first member that matches the filter criteria. |
|
Returns the member at an index in a collection which can be ordered and filtered using filter expression. |
|
The GetMemberValue function returns the specified field value of the first collection member that satisfies a given filter criteria. |
|
Returns the specified field value of member at an index in collection which can be ordered and filtered using filter expression. |
|
Returns the name of the element. |
|
Returns a datetime value having an Unspecified kind. |
|
Returns a datetime value having UTC kind. |
|
Gets specified value list by DataElement name. |
|
Returns xpath of the element. |
|
Returns true if the first expression is greater than the second expression. |
|
Returns true if the first expression is greater than or equal to the second expression. |
|
The HasWhitespace function returns true if a given string starts with, ends with, or contains duplicate whitespace. |
|
The Hour function returns the hour of the day for a given DateTime (0 to 23). |
|
The HourDiff function returns the number of hours between two DateTime values. |
|
The If function returns one of two values, depending on a given condition. |
|
The IfCase function compares a test value against a list of values, returning the result from the first matching pair. |
|
The IfChain function returns the return value from the first true condition in a list. |
|
The Instr function returns the position of the first occurrence of one string within another string. |
|
Returns the value (if any) of an instance method call on (an defined by) an entity. |
|
Returns the end-of-period interest payment for given present value at specified rate for specified period. |
|
Returns true if a value is equal to or between two boundary values. |
|
Returns true the given field meets the criteria to belong to the given classification. |
|
The IsDate function determines if an expression is a valid Date (or a DateTime with a zero time offset). |
|
The IsDateTime function determines if an expression is a valid DateTime. |
|
Returns true if the element is invalid. |
|
Returns true if the given value is contained in the specified value list, otherwise returns false. |
|
The IsLeapYear function returns true if the year is a leap year. |
|
Returns true if the expression is a valid Local kind datetime. |
|
Determines if a given value is found in a list of values. |
|
The IsNotNullOrEmpty function returns true if a field is not null or empty. |
|
The IsNull function returns true if a field is null. |
|
The IsNullOrEmpty function returns true if a field is null or empty. |
|
Returns true if a value is or can be converted to a number without error. |
|
Determines if an expression matches a Regular Expression pattern. |
|
Returns true if the expression is a valid unspecified kind datetime. |
|
Returns true if the expression is a valid UTC kind datetime. |
|
Returns true if the element is valid. |
|
The IsWeekday function returns true if a given DateTime is not a Saturday or Sunday. |
|
Returns true if the given date is a Saturday or Sunday. |
|
Determines if an expression matches an DOS-style wildcard expression. |
|
The JsonLookup function returns the JSON of the first property or array that matches a given search path. Does not support retrieving an array of primitive values. |
|
Returns the largest value in a list of values. |
|
The Left function returns a string containing a specified number of characters from the left side of a string. |
|
Returns the length of a string. |
|
Returns the length of a string. |
|
Returns true if the first expression is less than the second expression. |
|
Returns true if the first expression is less than or equal to the second expression. |
|
Returns the natural (base e) logarithm of a specified number. |
|
Returns the value from a table for the first row that satisfies the filter. |
|
Returns largest value of a member field or expression across a collection. |
|
The Mid function returns a substring of a string. |
|
The Millisecond function returns the milliseconds for a given DateTime (0 to 999). |
|
The MillisecondDiff function returns the number of milliseconds between two DateTime values. |
|
Returns smallest value of a member field or expression across a collection. |
|
Subtracts the value of one numeric expression from another. |
|
The Minute function returns the minute of the hour for a given DateTime (0 to 59). |
|
The MinuteDiff function returns the number of minutes between two DateTime values. |
|
Divides two numbers and returns only the remainder. |
|
Returns the month for a given Date or DateTime. |
|
The MonthDiff function returns the number of months between two Date values. |
|
Multiplies the value of one numeric expression by another. |
|
The NoneAreFalse function returns true if none of the provided conditions is false. Otherwise false. |
|
The NoneAreTrue function returns true if none of the provided conditions is true. Otherwise false. |
|
The Not function performs logical negation. |
|
Return true if two expressions are not equal. |
|
Return true if two expressions are not equal. |
|
The Now function returns the current date and time in the local time zone, as of the start of rule processing. |
|
The NumberOfFalse function returns the number of provided conditions that evaluate as false. |
|
The NumberOfTrue function returns the number of provided conditions that evaluate as true. |
|
Returns the number of digits in a given number, not counting trailing zeros to the right of the decimal point nor any leading zeros. |
|
Returns the number of digits in a given number that appear to the right of the decimal point, not counting trailing zeros. |
|
Returns the number of digits in a given number that appear to the left of the decimal point, not counting preceding zeros. |
|
Returns the value of a field within the outer context of an aggregate expression. |
|
Returns the value of a field within the outer context of an aggregate expression. |
|
The Percent function returns (value * percent) / 100.0. |
|
Adds the value of one numeric expression to another. |
|
Returns the end-of-period payment for given present value at specified rate for specified period. Note: The result is not negated as a debt. (e.g. PMT(0, 10, 10000) = 1000.00 not -1000.00) |
|
Takes the value of one numeric expression to the power of the exponent value. |
|
Returns the end-of-period principal payment for given present value at specified rate for specified period. |
|
The ProperCase function returns a copy of a string with the first letter of every word capitalized and the rest of the letters in lower case. |
|
Returns the end-of-period present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made |
|
Gets value list from Query. |
|
Returns a random integer between the specified minimum and maximum values. |
|
Returns the end-of-period interest rate which must be applied to the present value in order to arrive at the future value when compounded over the given number of periods |
|
Replaces all occurrences of a Regular Expression pattern with a string. |
|
Returns first match of regular expression pattern going left to right. |
|
The Replace function replaces all occurrences of a substring with another string. |
|
The Right function returns a string containing a specified number of characters from the right side of a string. |
|
The Round function rounds a number to a specified number of decimal places. |
|
The RoundDown function rounds a number down to a specified number of decimal places. |
|
The RoundUp function rounds a number up to a specified number of decimal places. |
|
Returns the value of the supplied expression or returns the default value if the expression produces an error. |
|
The Second function returns the seconds for a given DateTime (0 to 59). |
|
The SecondDiff function returns the number of seconds between two DateTime values. |
|
Returns the smallest value from a list of values. |
|
The Sqrt function returns the square root of a number. |
|
Determines if a text string or expression starts with another text string or expression. |
|
Returns the sum of a specified member or expression across a collection. |
|
Returns the value from a table for the first row that satisfies the field matching criteria. |
|
The ToBool function converts an expression to a boolean value. |
|
The ToDate function converts an expression to a Date value. |
|
The ToDateTime function converts an expression to a DateTime value. |
|
Returns the current date as of the start of rule processing. |
|
Returns the inner xml (does not include the outer element) for an Entity or Entity Field. |
|
The ToInt function converts an expression to an integer value. |
|
Returns the JSON for an Entity or Entity Field. |
|
Returns a list object from a collection. |
|
The ToLower function returns a copy of a string, converted to all lower case. |
|
The ToNumber function converts an expression to a numeric value. |
|
The ToString function converts an expression to a string value. |
|
The ToTime function returns a time based on source parameters. The date portion is 1/2/0001. |
|
The ToUpper function returns a copy of a string, converted to all upper case. |
|
Constructs value list inline from args. |
|
Returns the xml for an Entity or Entity Field. |
|
The Trim function returns a copy of a string with all leading and trailing spaces removed. |
|
The TrimWhitespace function removes leading, trailing, and duplicate whitespace from a string. |
|
Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified. |
|
The WeekdayDiff function returns the number of weekdays between two Date values. |
|
The XmlLookup function returns the value referenced by an XPath from an XML document or string. |
|
Returns the year for a given Date or DateTime. |
|
The YearDiff function returns the number of years between two Date values. |
Comments
0 comments
Please sign in to leave a comment.