Class SQLFunctionIf
- java.lang.Object
-
- com.arcadedb.query.sql.function.SQLFunctionAbstract
-
- com.arcadedb.query.sql.function.misc.SQLFunctionIf
-
- All Implemented Interfaces:
SQLFunction
public class SQLFunctionIf extends SQLFunctionAbstract
Returns different values based on the condition. If it's true the first value is returned, otherwise the second one.
Syntax:if(<field|value|expression>, <return_value_if_true> [,<return_value_if_false>])
Examples:SELECT if(rich, 'rich', 'poor') FROM ...
SELECT if( eval( 'salary > 1000000' ), 'rich', 'poor') FROM ...- Author:
- Luca Garulli (l.garulli--(at)--gmail.com)
-
-
Field Summary
Fields Modifier and Type Field Description static String
NAME
-
Fields inherited from class com.arcadedb.query.sql.function.SQLFunctionAbstract
name
-
-
Constructor Summary
Constructors Constructor Description SQLFunctionIf()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description Object
execute(Object iThis, Identifiable iCurrentRecord, Object iCurrentResult, Object[] iParams, CommandContext iContext)
Process a record.String
getSyntax()
Returns a convenient SQL String representation of the function.-
Methods inherited from class com.arcadedb.query.sql.function.SQLFunctionAbstract
aggregateResults, config, getName, getResult, toString
-
-
-
-
Field Detail
-
NAME
public static final String NAME
- See Also:
- Constant Field Values
-
-
Method Detail
-
execute
public Object execute(Object iThis, Identifiable iCurrentRecord, Object iCurrentResult, Object[] iParams, CommandContext iContext)
Description copied from interface:SQLFunction
Process a record.iCurrentRecord
- : current recordiCurrentResult
- TODOiParams
- : function parameters, number is ensured to be within minParams and maxParams.iContext
- : object calling this function- Returns:
- function result, can be null. Special cases : can be null if function aggregate results, can be null if function filter results : this mean result is excluded
-
getSyntax
public String getSyntax()
Description copied from interface:SQLFunction
Returns a convenient SQL String representation of the function.Example :
myFunction( param1, param2, [optionalParam3])
This text will be used in exception messages.
- Returns:
- String , never null.
-
-