Modifier and Type | Method and Description |
---|---|
Function |
DefaultFunctionRegistry.createFunction(String name) |
Function |
FunctionRegistry.createFunction(String name) |
Function[] |
DefaultFunctionRegistry.getFunctions() |
Function[] |
FunctionRegistry.getFunctions() |
Function[] |
DefaultFunctionRegistry.getFunctionsByCategory(FunctionCategory category) |
Function[] |
FunctionRegistry.getFunctionsByCategory(FunctionCategory category) |
Modifier and Type | Class and Description |
---|---|
class |
BeginsWithFunction
This function checks to see if a substring is within a larger string and is needed for the inline ETL implementation
of Pentaho Metadata.
|
class |
ContainsFunction
This function checks to see if a substring is within a larger string and is needed for the inline ETL implementation
of Pentaho Metadata.
|
class |
EndsWithFunction
This function checks to see if a substring is within a larger string and is needed for the inline ETL implementation
of Pentaho Metadata.
|
class |
EqualsFunction |
class |
InFunction |
class |
LikeFunction
This function is similar to the LIKE function in SQL, and is needed for the inline ETL implementation of Pentaho
Metadata.
|
Modifier and Type | Class and Description |
---|---|
class |
DateDifFunction
This function returns the number of years, months, or days between two date numbers.
The Format is a code from the following table, entered as text, that specifies the format you want: format Returns the number of y Years m Months. |
class |
DateFunction
Creation-Date: 04.11.2006, 18:59:11
|
class |
DateTimeValueFunction
This function returns
|
class |
DateValueFunction
This function returns
|
class |
DayFunction
This function extracts the day from a date.
|
class |
DaysFunction
This is the same as DATEDIFF(date_1, date_2, "d");
|
class |
HourFunction
This function extracts the hour (0 through 23) from a time.
|
class |
MinuteFunction
This function extracts the minute (0 through 59) from a time.
|
class |
MonthEndFunction
This function calculates the last day of the month
|
class |
MonthFunction
This function extracts the month from a date.
|
class |
NowFunction
Return the serial number of the current date and time.
|
class |
PrevWeekdayFunction |
class |
SecondFunction
This function extracts the minute (0 through 59) from a time.
|
class |
TimeFunction
This fonction constructs a time from hours, minutes, and seconds.
|
class |
TimeValueFunction
This fonction constructs a time from hours, minutes, and seconds.
|
class |
TodayFunction |
class |
WeekDayFunction
This function extracts the day of week from a date.
|
class |
YearFunction
This function extracts the year from a date.
|
class |
YesterdayFunction |
Modifier and Type | Class and Description |
---|---|
class |
ChooseFunction
This function uses an index to return a value from a list of values.
|
class |
CountAFunction
This function counts the number of non-empty values in the list of AnySequences provided.
|
class |
CountBlankFunction
This function counts the number of blank cells in the Reference provided.
|
class |
CountFunction
This function counts the numbers in the list of NumberSequences provided.
|
class |
ErrorFunction |
class |
HasChangedFunction
Creation-Date: 24.11.2006, 13:02:41
|
class |
IndexFunction |
class |
IsBlankFunction
Document me!
|
class |
IsErrFunction
This function returns true if the parameter is of error and not of error type NA.
|
class |
IsErrorFunction
This function returns true if the parameter is of error.
|
class |
IsEvenFunction
This function retruns true if the given value is an even number.
|
class |
IsLogicalFunction
This function checks whatever the given value is of Logical type.
|
class |
IsNaFunction
This function returns true if the parameter is of error type NA.
|
class |
IsNonTextFunction
This function retruns false if the given value is of type Text.
|
class |
IsNumberFunction
This function retruns true if the given value is of type Number.
|
class |
IsOddFunction
This function retruns true if the given value is an odd number.
|
class |
IsRefFunction
This function retruns true if the given value is reference.
|
class |
IsTextFunction
This function retruns true if the given value is of type Text.
|
class |
LookupFunction |
class |
NaFunction
This function class represents the constant error NA.
|
class |
ValueFunction
This function returns the number value of a text string.
|
Modifier and Type | Class and Description |
---|---|
class |
AndFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
FalseFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
IfFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
IfNaFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
NotFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
OrFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
TrueFunction
Creation-Date: 04.11.2006, 18:28:15
|
class |
XorFunction
Creation-Date: 04.11.2006, 18:28:15
|
Modifier and Type | Class and Description |
---|---|
class |
AbsFunction
This function returns the absolute (nonnegative) of the value.
|
class |
AcosFunction
This function returns the acos of the value.
|
class |
AcoshFunction
This function returns the acos of the value.
|
class |
AsinFunction
This function returns the acos of the value.
|
class |
Atan2Function
This function returns the acos of the value.
|
class |
AtanFunction
This function returns the acos of the value.
|
class |
AverageAFunction
This function returns the average of the number sequence.
|
class |
AverageFunction
This function returns the average of the number sequence.
|
class |
CosFunction
This function returns the acos of the value.
|
class |
EvenFunction
This function returns the rounding of a number up to the nearest even integer.
|
class |
ExpFunction
This function returns the acos of the value.
|
class |
LnFunction
This function returns the acos of the value.
|
class |
Log10Function
This function returns the acos of the value.
|
class |
LogFunction
This function returns the acos of the value.
|
class |
MaxAFunction
This function returns the maximum from a set of numbers.
|
class |
MaxFunction
This function returns the maximum from a set of numbers.
|
class |
MinAFunction
This function returns the minimum from a set of numbers.
|
class |
MinFunction
This function returns the minimum from a set of numbers.
|
class |
ModFunction
This function returns the remainder when one number is divided by another number.
|
class |
NFunction |
class |
OddFunction
This function returns the rounding a number up to the nearest odd integer, where "up" means "away from 0".
|
class |
PiFunction
This function returns the acos of the value.
|
class |
PowerFunction
This function returns the value of one number raised to the power of another number.
|
class |
SinFunction
This function returns the acos of the value.
|
class |
SqrtFunction
This function returns the sqrt of the value.
|
class |
SumAFunction
Creation-Date: 31.10.2006, 17:39:19
|
class |
SumFunction
Creation-Date: 31.10.2006, 17:39:19
|
class |
VarFunction
This function returns the acos of the value.
|
Modifier and Type | Class and Description |
---|---|
class |
IntFunction
This function returns a number down to the nearest integer.
|
Modifier and Type | Class and Description |
---|---|
class |
AscFunction |
class |
CharFunction
This function returns the given value as text.
|
class |
CleanFunction |
class |
CodeFunction
This function returns the given value as text.
|
class |
ConcatenateFunction
This function returns the given value as text.
|
class |
DollarFunction
This function returns the given value as text.
|
class |
ExactFunction
This function reports if two given text values are exactly equal using a case-sensitive comparison.
|
class |
FindFunction
This function returns the starting position of a given text in the given text.
|
class |
FixedFunction
This function returns the given value as text.
|
class |
LeftFunction
This function returns a selected number of text characters from the left.
This function depends on MidFunction . |
class |
LenFunction
This function returns the lengh in characters of the given value.
|
class |
LowerFunction
This function returns the given text in lower case.
|
class |
MessageFunction |
class |
MidFunction
This function returns extracted text, given an original text, starting position, and length.
|
class |
ProperFunction |
class |
ReplaceFunction
This function returns text where an old text is substituted with a new text.
|
class |
ReptFunction
This function returns text repeated Count times.
|
class |
RightFunction
This function returns a selected number of text characters from the right.
This function depends on MidFunction . |
class |
SearchFunction
This function returns the starting position of a given text in the given text.
|
class |
StringCountFunction
This function counts the occurences of search_text in text.
|
class |
SubstituteFunction
This function returns text where an old text is substituted with a new text.
|
class |
TextFunction
This function returns the given value as text.
|
class |
TFunction
This function returns the given text value or a zero lenght string for non text type.
|
class |
TrimFunction
This function returns the given text free of leading spaces.
|
class |
UnicharFunction
This function returns the given value as text.
|
class |
UnicodeFunction
This function returns the given value as text.
|
class |
UpperFunction
This function returns the given text in upper case.
|
class |
URLEncodeFunction
This function encodes a given text using the URL-Encoding schema.
|
Modifier and Type | Class and Description |
---|---|
class |
ArrayConcatenateFunction |
class |
ArrayContainsFunction |
class |
ArrayLeftFunction |
class |
ArrayMidFunction |
class |
ArrayRightFunction |
class |
CsvArrayFunction |
class |
CsvTextFunction |
class |
NormalizeArrayFunction |
class |
NullFunction
Deprecated.
|
class |
ParseDateFunction |
class |
SequenceQuoterFunction |
Modifier and Type | Method and Description |
---|---|
Function |
FormulaFunction.getFunction()
Returns the initialized function.
|
Copyright © 2002–2017 Pentaho Corporation. All rights reserved.