CoalesceInterface

interface \TYPO3\CMS\Extbase\Persistence\Generic\Qom\CoalesceInterface

Extends
FunctionExpressionInterface

Evaluates to the first non-NULL value among the operands.

Usage example: $query->orderBy($query->coalesce('nickname', 'firstName'), QueryInterface::ORDER_ASCENDING);

Table of Contents

Methods

getFunctionName()  : string
Returns the SQL function name.
getOperands()  : (DynamicOperandInterface|string)[]
Returns the operands of this function expression.

Methods

getFunctionName()

Returns the SQL function name.

public getFunctionName() : string

Return values

string —

The function name (e.g., 'CONCAT', 'TRIM', 'COALESCE')

On this page