Review main Merged

92646[FEATURE] Add expression builder for Extbase query orderings

Benni Mack CR +2 V +2 Hard +777 −6 updated 02/08/26, 09:50

Commit message

Extbase queries now support SQL function expressions in ORDER BY
clauses through a new fluent API. This enables sorting results by
computed values using functions like CONCAT, TRIM, and COALESCE.

New methods added to QueryInterface:
 - orderBy() / addOrderBy() - Fluent ordering API
 - concat() - Creates a CONCAT expression
 - trim() - Creates a TRIM expression
 - coalesce() - Creates a COALESCE expression

Example usage:

  $query->orderBy(
    $query->concat('firstName', 'lastName'),
    QueryInterface::ORDER_ASCENDING
  );

The existing setOrderings() array syntax remains fully supported
for backwards compatibility.

Review

  • Code review CR +2 Done
    • Benni Mack +2
    • Garvin Hicking +1
    • Simon Schaufelberger +1
  • Verified V +2 Done
    • Benni Mack +2
    • Garvin Hicking +1
    • Simon Schaufelberger +1
    • core-ci +1 CI

Issues 1

Files 13

Review log 67

  1. Benni Mack uploaded patch set 1 02/03/26, 17:06

  2. core-ci voted on patch set 1 V +1 02/03/26, 17:14 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/94931

  3. Benni Mack marked it ready for review 02/04/26, 18:15

  4. Garvin Hicking voted on patch set 1 CR +1 V +1 02/05/26, 09:47

  5. Simon Schaufelberger voted on patch set 1 CR +1 V +1 02/05/26, 09:58

  6. Benni Mack voted on patch set 1 CR +2 V +2 02/08/26, 09:50

  7. Benni Mack merged patch set 2 02/08/26, 09:50