Feature #47812


Query support for BETWEEN

Added by Pascal Dürsteler about 11 years ago. Updated over 6 years ago.

Should have
Database API (Doctrine DBAL)
Target version:
Start date:
Due date:
% Done:


Estimated time:
PHP Version:
Sprint Focus:


I would like to introduce the between-operator into the query class. This would allow shorter queries, and maybe a better performance for queries currently relying on two conditions.

So instead of

  $query->greaterThanOrEqual($propertyName, $operand),
  $query->lessThanOrEqual($propertyName, $operand)

One could simply write

  $query->between($propertyName, $minOperand, $maxOperand)

What do you think?

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #90794: Add between() method to QueryInterfaceRejectedStefan Froemken2020-03-20

Actions #1

Updated by Alexander Schnitzler about 11 years ago

  • Status changed from New to Needs Feedback

I just googled a bit and it seems there's no real difference in performance using between, in or "> <". So I think the underlying sql does not have to be adjusted but for sure the between constraint is a nice shortcut.

Unfortunetly I did not find the support in Flow so I will pass this on to my team mates to decide.

Actions #2

Updated by Anja Leichsenring about 11 years ago

  • Target version set to Extbase 6.3
Actions #3

Updated by Felix Oertel almost 11 years ago

  • Assignee set to Tymoteusz Motylewski

Guess Xavier should tip us up with some hint about dbal (or other storage engines in general) supporting "between".

Actions #4

Updated by Alexander Opitz over 9 years ago

  • Project changed from 534 to TYPO3 Core
  • Category changed from Extbase: Generic Persistence to Extbase
  • Assignee changed from Tymoteusz Motylewski to Xavier Perseguers
  • Target version changed from Extbase 6.3 to 7.0

Hi Xavier,

it seams the question about "between" was for you.

Actions #5

Updated by Xavier Perseguers over 9 years ago

  • Category changed from Extbase to Database API (Doctrine DBAL)
  • Status changed from Needs Feedback to New
  • Assignee deleted (Xavier Perseguers)

Would be a nice addition, for sure.

Actions #6

Updated by Mathias Schreiber over 9 years ago

  • Target version changed from 7.0 to 7.1 (Cleanup)
Actions #7

Updated by Benni Mack about 9 years ago

  • Target version changed from 7.1 (Cleanup) to 7.4 (Backend)
Actions #8

Updated by Morton Jonuschat almost 9 years ago

  • Assignee set to Morton Jonuschat
  • Target version changed from 7.4 (Backend) to 7.5
Actions #9

Updated by Gerrit Code Review almost 9 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at

Actions #10

Updated by Morton Jonuschat almost 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #11

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions #12

Updated by Christian Eßl about 4 years ago

  • Related to Task #90794: Add between() method to QueryInterface added

Also available in: Atom PDF