Feature: #76259 - Introduce buildQueryParametersPostProcess Hook¶

Description¶

With the migration to Doctrine the hook buildQueryParameters has been introduced in the class DatabaseRecordList. This hook replaces the hook makeQueryArray from the deprecated method AbstractDatabaseRecordList::makeQueryArray.

Using this hook allows modifying the parameters used to query the database for records to be shown in the record list view.

The hook-object needs to be registered in $GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS'][\TYPO3\CMS\Recordlist\RecordList\DatabaseRecordList::class]['buildQueryParameters'][] and implement the public method buildQueryParametersPostProcess.

The signature of the buildQueryParametersPostProcess method is as following:

public function buildQueryParametersPostProcess(
    array $parameters,
    string $table,
    int $pageId,
    array $additionalConstraints,
    array $fieldList,
    AbstractDatabaseRecordList $parentObject
) : void {
}

The following fields are part of the $parameters array and can be modified:

Key	Type	Description
table	string	The queried tablename
fields	string[]	The columns to retrieve
groupBy	string[]	The columns to group the result by
firstResult	int\|null	The offset to start retrieve rows from
maxResults	int\|null	The maximum number of rows to retrieve
orderBy	array[]	Array of arrays containing fieldname/sorting pairs
where	string[]	Array of where conditions to apply to the database query.