Comparison implements ComparisonInterface
Filters node-tuples based on the outcome of a binary operation.
For any comparison, operand2 always evaluates to a scalar value. In contrast, operand1 may evaluate to an array of values (for example, the value of a multi-valued property), in which case the comparison is separately performed for each element of the array, and the Comparison constraint is satisfied as a whole if the comparison against any element of the array is satisfied.
If operand1 and operand2 evaluate to values of different property types, the value of operand2 is converted to the property type of the value of operand1. If the type conversion fails, the query is invalid.
If operator is not supported for the property type of operand1, the query is invalid.
If operand1 evaluates to null (for example, if the operand evaluates the value of a property which does not exist), the constraint is not satisfied.
The OPERATOR_EQUAL_TO operator is satisfied only if the value of operand1 equals the value of operand2.
The OPERATOR_NOT_EQUAL_TO operator is satisfied unless the value of operand1 equals the value of operand2.
The OPERATOR_LESS_THAN operator is satisfied only if the value of operand1 is ordered before the value of operand2.
The OPERATOR_LESS_THAN_OR_EQUAL_TO operator is satisfied unless the value of operand1 is ordered after the value of operand2.
The OPERATOR_GREATER_THAN operator is satisfied only if the value of operand1 is ordered after the value of operand2.
The OPERATOR_GREATER_THAN_OR_EQUAL_TO operator is satisfied unless the value of operand1 is ordered before the value of operand2.
The OPERATOR_LIKE operator is satisfied only if the value of operand1 matches the pattern specified by the value of operand2, where in the pattern: the character "%" matches zero or more characters, and the character "_" (underscore) matches exactly one character, and the string "\x" matches the character "x", and all other characters match themselves.
only to be used within Extbase, not part of TYPO3 Core API.
Table of Contents
Interfaces
- ComparisonInterface
- Filters node-tuples based on the outcome of a binary operation.
Properties
- $operand1 : PropertyValueInterface
- $operand2 : mixed
- $operator : int
Methods
- __construct() : mixed
- Constructs this Comparison instance
- collectBoundVariableNames() : mixed
- Fills an array with the names of all bound variables in the constraints
- getOperand1() : PropertyValueInterface
- Gets the first operand.
- getOperand2() : mixed
- Gets the second operand.
- getOperator() : string
- Gets the operator.
Properties
$operand1
protected
PropertyValueInterface
$operand1
$operand2
protected
mixed
$operand2
$operator
protected
int
$operator
Methods
__construct()
Constructs this Comparison instance
public
__construct(PropertyValueInterface $operand1, int $operator, mixed $operand2) : mixed
Parameters
- $operand1 : PropertyValueInterface
- $operator : int
-
one of QueryInterface::OPERATOR_*
- $operand2 : mixed
collectBoundVariableNames()
Fills an array with the names of all bound variables in the constraints
public
collectBoundVariableNames(array<string|int, mixed> &$boundVariables) : mixed
Parameters
- $boundVariables : array<string|int, mixed>
getOperand1()
Gets the first operand.
public
getOperand1() : PropertyValueInterface
Return values
PropertyValueInterface —the operand; non-null
getOperand2()
Gets the second operand.
public
getOperand2() : mixed
Return values
mixed —the operand; non-null
getOperator()
Gets the operator.
public
getOperator() : string
Return values
string —One of QueryInterface::OPERATOR_*