ModifyDatabaseQueryForContentEvent 

Use the PSR-14 event \TYPO3\CMS\Backend\View\Event\ModifyDatabaseQueryForContentEvent to filter out certain content elements from being shown in the Content > Layout module.

Example: Hide content elements by a field value in the Page module 

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\Attribute\AsEventListener;
use TYPO3\CMS\Core\Database\Connection;

#[AsEventListener(
  identifier: 'my-extension/backend/modify-database-query-for-content',
)]
final readonly 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);
  }
}
Copied!

API 

final class ModifyDatabaseQueryForContentEvent
Fully qualified name
\TYPO3\CMS\Backend\View\Event\ModifyDatabaseQueryForContentEvent

Use this Event to alter the database query when loading content for a page.

getQueryBuilder()
Returns
\TYPO3\CMS\Core\Database\Query\QueryBuilder
setQueryBuilder(\TYPO3\CMS\Core\Database\Query\QueryBuilder $queryBuilder)
param $queryBuilder

the queryBuilder

getTable()
Returns
string
getPageId()
Returns
int