ModifyDatabaseQueryForContentEvent¶
New in version 12.0: This event has been introduced which serves as a drop-in replacement for the removed
$GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS'][PageLayoutView::class]['modifyQuery']
hook.
Use the PSR-14 event \TYPO3\CMS\Backend\View\Event\ModifyDatabaseQueryForContentEvent
to filter out certain content elements from being shown in the
Page module.
Example¶
Registration of the event in your extension's Services.yaml
:
EXT:my_extension/Configuration/Services.yaml¶
services:
# Place here the default dependency injection configuration
MyVendor\MyExtension\Backend\EventListener\MyEventListener:
tags:
- name: event.listener
identifier: 'my-extension/backend/modify-database-query-for-content'
Read how to configure dependency injection in extensions.
The corresponding event listener class:
EXT:my_extension/Classes/Backend/EventListener/MyEventListener.php¶
<?php
declare(strict_types=1);
namespace MyVendor\MyExtension\Backend\EventListener;
use TYPO3\CMS\Backend\View\Event\ModifyDatabaseQueryForContentEvent;
use TYPO3\CMS\Core\Database\Connection;
final class MyEventListener
{
public function __invoke(ModifyDatabaseQueryForContentEvent $event): void
{
// Early return if we do not need to react
if ($event->getTable() !== 'tt_content') {
return;
}
// Retrieve QueryBuilder instance from event
$queryBuilder = $event->getQueryBuilder();
// Add an additional condition to the QueryBuilder for the table
// Note: This is only a example, modify the QueryBuilder instance
// here to your needs.
$queryBuilder = $queryBuilder->andWhere(
$queryBuilder->expr()->neq(
'some_field',
$queryBuilder->createNamedParameter(1, Connection::PARAM_INT)
)
);
// Set updated QueryBuilder to event
$event->setQueryBuilder($queryBuilder);
}
}
API¶
- class TYPO3\CMS\Backend\View\Event\ModifyDatabaseQueryForContentEvent¶
Use this Event to alter the database query when loading content for a page.
- getQueryBuilder()¶
- Return type
TYPO3\CMS\Core\Database\Query\QueryBuilder
- setQueryBuilder(TYPO3\\CMS\\Core\\Database\\Query\\QueryBuilder $queryBuilder)¶
- Parameters
$queryBuilder (
TYPO3\CMS\Core\Database\Query\QueryBuilder
) -- the queryBuilder
- getTable()¶
- Return type
string
- getPageId()¶
- Return type
int