Query deprecated
class Query implements QueryInterface (View source)
deprecated
The Query class used to run queries like $query->matching($query->equals('foo', 'bar'))->setLimit(10)->execute();
Properties
| protected string | $type | ||
| protected ClassSchema | $classSchema | ||
| protected ObjectManagerInterface | $objectManager | ||
| protected QueryObjectModelFactory | $qomFactory | ||
| protected Constraint | $constraint | ||
| protected array | $orderings | The property names to order the result by. Expected like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING ) |
|
| protected int | $limit | ||
| protected bool | $distinct | ||
| protected int | $offset |
Methods
Constructs a query object working on the given type
Returns the type this query cares for.
Executes the query and returns the result
Returns the query result count
Sets the property names to order the result by. Expected like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
Returns the property names to order the result by, like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
Sets the maximum size of the result set to limit. Returns $this to allow for chaining (fluid interface)
Returns the maximum size of the result set to limit.
Sets the DISTINCT flag for this query.
Returns the DISTINCT flag for this query.
Sets the start offset of the result set to $offset. Returns $this to allow for chaining (fluid interface)
Returns the start offset of the result set.
The constraint used to limit the result set. Returns $this to allow for chaining (fluid interface)
Gets the constraint for this query.
Performs a logical conjunction of the two given constraints. The method takes one or more contraints and concatenates them with a boolean AND.
Performs a logical disjunction of the two given constraints. The method takes one or more constraints and concatenates them with a boolean OR.
Performs a logical negation of the given constraint
Returns an equals criterion used for matching objects against a query.
Returns a like criterion used for matching objects against a query.
Returns a "contains" criterion used for matching objects against a query.
Returns an "isEmpty" criterion used for matching objects against a query.
Returns an "in" criterion used for matching objects against a query. It matches if the property's value is contained in the multivalued operand.
Returns a less than criterion used for matching objects against a query
Returns a less or equal than criterion used for matching objects against a query
Returns a greater than criterion used for matching objects against a query
Returns a greater than or equal criterion used for matching objects against a query
Details
__construct(string $type, ReflectionService $reflectionService)
Constructs a query object working on the given type
void
injectObjectManager(ObjectManagerInterface $qomFactory)
Injects the Flow object factory
void
injectQomFactory(QueryObjectModelFactory $qomFactory)
Injects the Flow QOM factory
string
getType()
Returns the type this query cares for.
QueryResultInterface
execute(bool $cacheResult = false)
Executes the query and returns the result
int
count()
Returns the query result count
QueryInterface
setOrderings(array $orderings)
Sets the property names to order the result by. Expected like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
array
getOrderings()
Returns the property names to order the result by, like this: array( 'foo' => \Neos\Flow\Persistence\QueryInterface::ORDER_ASCENDING, 'bar' => \Neos\Flow\Persistence\QueryInterface::ORDER_DESCENDING )
QueryInterface
setLimit(int $limit)
Sets the maximum size of the result set to limit. Returns $this to allow for chaining (fluid interface)
getLimit()
Returns the maximum size of the result set to limit.
QueryInterface
setDistinct(bool $distinct = true)
Sets the DISTINCT flag for this query.
bool
isDistinct()
Returns the DISTINCT flag for this query.
QueryInterface
setOffset(int $offset)
Sets the start offset of the result set to $offset. Returns $this to allow for chaining (fluid interface)
int
getOffset()
Returns the start offset of the result set.
QueryInterface
matching(object $constraint)
The constraint used to limit the result set. Returns $this to allow for chaining (fluid interface)
mixed
getConstraint()
Gets the constraint for this query.
object
logicalAnd(mixed $constraint1)
Performs a logical conjunction of the two given constraints. The method takes one or more contraints and concatenates them with a boolean AND.
It also accepts a single array of constraints to be concatenated.
object
logicalOr(mixed $constraint1)
Performs a logical disjunction of the two given constraints. The method takes one or more constraints and concatenates them with a boolean OR.
It also accepts a single array of constraints to be concatenated.
object
logicalNot(object $constraint)
Performs a logical negation of the given constraint
object
equals(string $propertyName, mixed $operand, bool $caseSensitive = true)
Returns an equals criterion used for matching objects against a query.
It matches if the $operand equals the value of the property named $propertyName. If $operand is NULL a strict check for NULL is done. For strings the comparison can be done with or without case-sensitivity.
object
like(string $propertyName, string $operand, bool $caseSensitive = true)
Returns a like criterion used for matching objects against a query.
Matches if the property named $propertyName is like the $operand, using standard SQL wildcards.
object
contains(string $propertyName, mixed $operand)
Returns a "contains" criterion used for matching objects against a query.
It matches if the multivalued property contains the given operand.
If NULL is given as $operand, there will never be a match!
bool
isEmpty(string $propertyName)
Returns an "isEmpty" criterion used for matching objects against a query.
It matches if the multivalued property contains no values or is NULL.
object
in(string $propertyName, mixed $operand)
Returns an "in" criterion used for matching objects against a query. It matches if the property's value is contained in the multivalued operand.
object
lessThan(string $propertyName, mixed $operand)
Returns a less than criterion used for matching objects against a query
object
lessThanOrEqual(string $propertyName, mixed $operand)
Returns a less or equal than criterion used for matching objects against a query
object
greaterThan(string $propertyName, mixed $operand)
Returns a greater than criterion used for matching objects against a query
object
greaterThanOrEqual(string $propertyName, mixed $operand)
Returns a greater than or equal criterion used for matching objects against a query