ModifyDefaultConstraintsForDatabaseQueryEvent¶

New in version 13.0

This event serves as a replacement for the removed hook $GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_page.php']['addEnableColumns'].

The API class \TYPO3\CMS\Core\Domain\Repository\PageRepository has a method getDefaultConstraints() which accumulates common restrictions for a database query. The purpose is to limit queries for TCA-based tables, filtering out disabled or scheduled records.

The PSR-14 event \TYPO3\CMS\Core\Domain\Event\ModifyDefaultConstraintsForDatabaseQueryEvent allows to remove, alter or add constraints compiled by TYPO3 for a specific table to further limit these constraints.

The event contains a list of CompositeExpression objects, allowing to modify them via the getConstraints() and setConstraints(array $constraints) methods.

Example¶

Note

Currently, we do not have an example for this event. If you can provide a useful one, please open an issue with your code snippets or a pull request.

API¶

class \TYPO3\CMS\Core\Domain\Event\ ModifyDefaultConstraintsForDatabaseQueryEvent¶

Event which is fired when compiling the list of constraints such as "deleted" and "starttime", "endtime" etc.

This Event allows for additional enableColumns to be added or removed to the list of constraints.

An example: The extension ingmar_accessctrl enables assigning more than one usergroup to content and page records

getTable ( ) ¶

returntype: string

getTableAlias ( ) ¶

returntype: string

getExpressionBuilder ( ) ¶

returntype: TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder

getConstraints ( ) ¶

returntype: array

setConstraints ( array $constraints) ¶

param array $constraints: the constraints

getEnableFieldsToIgnore ( ) ¶

returntype: array

getContext ( ) ¶

returntype: TYPO3\CMS\Core\Context\Context