Project

General

Profile

Actions
Copy link

Feature #47812

closed

Query support for BETWEEN

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

Status:
Closed
Priority:
Should have
Assignee:
Morton Jonuschat
Category:
Database API (Doctrine DBAL)
Target version:
7.5
Start date:
2013-05-02
Due date:
% Done:

100%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

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->logicalAnd(
  $query->greaterThanOrEqual($propertyName, $operand),
  $query->lessThanOrEqual($propertyName, $operand)
);

One could simply write

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

What do you think?

Related issues 1 (0 open — 1 closed)

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

Actions
Actions
Copy link

Also available in: Atom PDF