[TYPO3-english]  logicalAnd + logicalOr
    Jan Kornblum 
    jan.kornblum at gmx.de
       
    Wed Nov 19 09:30:03 CET 2014
    
    
  
Hi newsgroup,
combining logicalAnd and logicalOr doesn't work for me, but maybe i 
misunderstand it:
$query->matching(
	$query->logicalOr(
		$query->greaterThanOrEqual('dateStart', $dateStart->format('Y-m-d 
00:00:00')),
		$query->logicalAnd(
			$query->lessThan('dateStart', $dateStart->format('Y-m-d 00:00:00')),
			$query->greaterThanOrEqual('dateEnd', $dateStart->format('Y-m-d 
00:00:00'))
		)
	)
);
In my words:
("dateStart" must be greater than the given value)
OR ELSE
("dateStart" must be less than the given value AND "dateEnd" must be 
greater than the given date)
But the second part (or else) seems to be ignored or will always be 
true...
Kind regards, Jan
    
    
More information about the TYPO3-english
mailing list