ModifyDatabaseQueryForRecordListingEvent
The PSR-14 event
\TYPO3\
allows to alter the query builder SQL
statement before a list of records is rendered in record lists, such as
the List module or an element browser.
Example
EXT:my_extension/Classes/Backend/EventListener/MyEventListener.php
<?php
declare(strict_types=1);
namespace MyVendor\MyExtension\Backend\EventListener;
use TYPO3\CMS\Backend\View\Event\ModifyDatabaseQueryForRecordListingEvent;
use TYPO3\CMS\Core\Attribute\AsEventListener;
#[AsEventListener(
identifier: 'my-extension/backend/modify-database-query-for-record-list',
)]
final readonly class MyEventListener
{
public function __invoke(ModifyDatabaseQueryForRecordListingEvent $event): void
{
$queryBuilder = $event->getQueryBuilder();
// ... do something ...
$event->setQueryBuilder($queryBuilder);
}
}
API
-
class
ModifyDatabaseQueryForRecordListingEvent -
- Fully qualified name
-
\TYPO3\CMS\ Backend\ View\ Event\ Modify Database Query For Record Listing Event
Use this Event to alter the database query when loading content for a page (usually in the records module) before it is executed.