Copied!

FilteringQueryBuilder

FilteringQueryBuilder.php : 29
Extends QueryBuilder

Repository Filtering query builder wrapper for \Doctrine\DBAL\Query\QueryBuilder.

NOTE: To be used only with Repository Content/Location Filtering feature.

Constants

publicSORT_ORDER_MAP

FilteringQueryBuilder.php : 31 
public mixed SORT_ORDER_MAP = [\Ibexa\Contracts\Core\Repository\Values\Content\Query::SORT_ASC => 'ASC', \Ibexa\Contracts\Core\Repository\Values\Content\Query::SORT_DESC => 'DESC']

Methods

publicaddOrderBy()

FilteringQueryBuilder.php : 127

Inherited from \Doctrine\DBAL\Query\QueryBuilder::addOrderBy.

 
public addOrderBy(string $sort[, string|null $order = null ]) : FilteringQueryBuilder

Parameters

Name Type Default value Description
$sort string - -
$order string|null null -

Return values

FilteringQueryBuilder

publicbuildOperatorBasedCriterionConstraint()

FilteringQueryBuilder.php : 171 
public buildOperatorBasedCriterionConstraint(string $columnName, array<string|int, mixed> $criterionValue, string $operator) : string

Parameters

Name Type Default value Description
$columnName string - -
$criterionValue array<string|int, mixed> - -
$operator string - -

Return values

string

Tags
Throws
DBALException

publicgetExistingTableAliasJoinCondition()

FilteringQueryBuilder.php : 102 
public getExistingTableAliasJoinCondition(string $tableAlias) : string

Parameters

Name Type Default value Description
$tableAlias string - -

Return values

string

conditions, null if table is not joined yet.

publicjoinAllLocations()

FilteringQueryBuilder.php : 234 
public joinAllLocations() : FilteringQueryBuilder

Return values

FilteringQueryBuilder

publicjoinOnce()

FilteringQueryBuilder.php : 38

Create table JOIN, but only if it hasn't been already joined (determined based on $tableAlias).

 
public joinOnce(string $fromAlias, string $tableName, string $tableAlias, string $conditions) : FilteringQueryBuilder

Parameters

Name Type Default value Description
$fromAlias string - -
$tableName string - -
$tableAlias string - -
$conditions string - -

Return values

FilteringQueryBuilder

Tags
Throws
DatabaseException

if conditions of pre-existing same alias joins are different

publicjoinPublishedVersion()

FilteringQueryBuilder.php : 210 
public joinPublishedVersion() : FilteringQueryBuilder

Return values

FilteringQueryBuilder

publicleftJoinOnce()

FilteringQueryBuilder.php : 71

Create table LEFT JOIN, but only if it hasn't been already joined (determined based on $tableAlias).

 
public leftJoinOnce(string $fromAlias, string $tableName, string $tableAlias, string $conditions) : FilteringQueryBuilder

Parameters

Name Type Default value Description
$fromAlias string - -
$tableName string - -
$tableAlias string - -
$conditions string - -

Return values

FilteringQueryBuilder

Tags
Throws
DatabaseException

if conditions of pre-existing same alias joins are different