This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions pageOpens in a new window (login required).

Caché & Ensemble 2018.1.5Opens in a new window > Class Reference > %SYS namespace > %DeepSee.Query.scalarFunction


class %DeepSee.Query.scalarFunction extends %Library.RegisteredObject

This class defines the set of scalar functions allowed within DeepSee queries.

Method Inventory (Including Private)

Methods (Including Private)

classmethod %EvaluateScalar(pFunc As %String, pValue1 As %String = "", pValue2 As %String = "", pValue3 As %String = "", pValue4 As %String = "") as %String
Evaluate the given scalar function, pFunc, and return the result.
classmethod %IsScalarFunction(pFunc As %String) as %String
Test if pFunc is a scalar function. Return -1 if function is not a scalar function, otherwise return the number of arguments and (total number of) optional arguments (args:optargs) expected by the function.
classmethod ISNULL(pValue As %Double, pReplacement As %Double) as %Double
IsNull scalar function: If value is "", return replacment,
classmethod LOG(pValue As %Double) as %Double
Log base 10 scalar function.
classmethod LOOKUP(pTermList As %String, pKey As %String, pDefault As %String = "", pField As %String = "") as %String
Lookup a value in a term list.
classmethod POWER(pValue As %Double, pArg As %Double) as %Double
Power scalar function.
classmethod ROUND(pValue As %Double, pDigits As %Integer = 0) as %Double
Round the given value to pDigits places.
classmethod SQRT(pValue As %Double) as %Double
Square root scalar function.

Inherited Members

Inherited Methods (Including Private)

FeedbackOpens in a new window