Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
Mappings:
/** * @Field(type="date", name="scheduled_at") */ private $scheduledAt; /** * @Field(type="date", name="completed_at") */ private $completedAt;
Query:
$qb->field('scheduledAt')->lte($now)
->addOr($qb->expr()->field('completedAt')->lte($now))
->addOr($qb->expr()->field('completedAt')->equals(null))
->sort('scheduledAt', 'asc');
Expected result:
db.foo.find({
"scheduled_at": { "$lte": new Date(...) },
"$or": [
{ "completed_at": { "$lte": new Date(...) } },
{ "completed_at": null } ]
})
.sort({ "scheduled_at": 1 });
Actual result:
db.foo.find({
"scheduled_at": { "$lte": new Date(...) },
"$or": [
{ "completedAt": { "$lte": new Date(...) } },
{ "completedAt": null } ]
})
.sort({ "scheduledAt": 1 });