Neos/Flow 6.3.21 -Query Builder - compare two entity properties

Using Neos & Flow
1

Hi!

I have an object class with the properties date1 and date2. I would like to find all instances with date1 > date2 with the query builder.

Something like this:

$query->greaterThan("date1", "date2")

Is it somehow possible?

Thank you!

Tobias

2

AFAIK, this is not possible with the Flow query builder.

But you can use the Doctrine query builder, which provides a lot more low level functionality.

$dqb = $repository->createQuery()->getQueryBuilder();
$dqb->andWhere('`date1` > `date2`');