Project

General

Profile

Actions

Bug #78386

closed

Error in between Query.

Added by Anonymous about 8 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2016-10-24
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

//With this query I get never results.

$constraints[] = $query->logicalAnd(
$query->greaterThanOrEqual('events.dateFrom', $DateFromStartFormated),
$query->lessThanOrEqual('events.dateTo', $DateToStartFormated)
);

//With this query I get results.

$constraints[] = $query->logicalAnd(
$query->greaterThanOrEqual('events.dateFrom', $DateFromStartFormated)//,
//$query->lessThanOrEqual('events.dateTo', $DateToStartFormated)
);

Actions #1

Updated by Morton Jonuschat almost 8 years ago

  • Status changed from New to Needs Feedback

I've tried to verify this and can't seem any failure in Extbase, can you provide an anonymized SQL dump of the rows it should find and the values for the input parameters $DateFromStartFormated and $DateToStartFormated?

Actions #2

Updated by Riccardo De Contardi over 7 years ago

  • Status changed from Needs Feedback to Closed

No feedback since 90 days > close.

If you think that this is the wrong decision or experience the issue again or if you have more information about how to reproduce it, then please reopen it or open a new issue with a reference to this one. Thank you.

Actions

Also available in: Atom PDF