Review main Ready for review Quiet

96114[FEATURE] Add CASE expressions to ExpressionBuilder

Wouter Wolters CR -2 V +1 Hard +312 −3 updated 10/18/26, 07:21

Commit message

Add a reusable caseWhen() builder for ordered WHEN/THEN pairs and an
ELSE expression. Use it for uidInList ordering in frontend queries,
replacing the inline SQL assembly.

Test this change

Run a command in your clone of the TYPO3 Core. Then try what the change does and vote on Verified in Gerrit. How to review a patch

Check out patch set 4
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/14/96114/4 && git checkout FETCH_HEAD
Cherry-pick onto main
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/14/96114/4 && git cherry-pick FETCH_HEAD

Review

  • Code review CR -2 Blocked
    • Benni Mack -2
    • Oliver Klee +1
    • Guido Schmechel +1
    • Alexander Schnitzler +1
    • Matthias Vogel +1
    • Simon Schaufelberger +1
  • Verified V +1 Needs a vote
    • Oliver Klee +1
    • Guido Schmechel +1
    • Alexander Schnitzler +1
    • Matthias Vogel +1
    • Simon Schaufelberger +1
    • core-ci +1 CI

Merge conflicts 7

Issues 2

Files 5

Review log 1317

  1. Wouter Wolters uploaded patch set 1 09/27/26, 14:00

  2. core-ci voted on patch set 1 V +1 09/27/26, 14:08 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/109372

  3. Wouter Wolters marked it ready for review 10/09/26, 19:30

  4. Guido Schmechel commented on patch set 1 10/17/26, 10:48

    Feature-110809-CaseElseExpressionBuilder.rst:14

    I'd like to see a code example here and find out what the final SQL command will be.
  5. Matthias Vogel uploaded patch set 2 V +1 10/17/26, 13:17

  6. Matthias Vogel updated the commit message in patch set 3 10/17/26, 13:18

  7. core-ci voted on patch set 2 V -1 10/17/26, 13:26 Core CI is not happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/111458

  8. core-ci voted on patch set 3 V -1 10/17/26, 13:27 Core CI is not happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/111459

  9. Matthias Vogel uploaded patch set 4 V -1 10/17/26, 13:35

  10. Matthias Vogel commented on patch set 4 CR +1 V +1 10/17/26, 13:35

    Feature-110809-CaseElseExpressionBuilder.rst:14 Reply

    Done
  11. core-ci voted on patch set 4 V +1 10/17/26, 13:43 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/111461

  12. Simon Schaufelberger voted on patch set 4 CR +1 V +1 10/17/26, 16:21

  13. Alexander Schnitzler voted on patch set 4 CR +1 V +1 10/17/26, 16:41

  14. Guido Schmechel voted on patch set 4 CR +1 V +1 10/17/26, 18:10

  15. Guido Schmechel commented on patch set 4 10/17/26, 18:10

    Feature-110809-CaseElseExpressionBuilder.rst:14 Reply

    Thanks!
  16. Oliver Klee voted on patch set 4 CR +1 V +1 10/17/26, 19:13

  17. Benni Mack commented on patch set 4 CR -2 10/18/26, 07:21

    Let's wait for Stefan on this. its his domain and he'Ll be back in a week