XF 2.3 Query Operators with findOne

[tenants]

I just hit a little snag, I think it's useful mentioning (even if it's self reference)


If I have stuff in the database, this will work fine as a query:

$expiredTime = \XF::$time - (7 * 86400);
$projectInvite =  \XF::app()->finder('Tenants\ToolsAdmin:ProjectInviteEntity')
    ->where('created_date', '>', $expiredTime) // 7 day expiration
    ->fetchOne(); // something returned

But this returns null:

$expiredTime = \XF::$time - (7 * 86400);
$projectInvite = $this->em()->findOne('Tenants\ToolsAdmin:ProjectInviteEntity', [
    'created_date' => ['>', $expiredTime],
]); // null returned, ehhhh?

It seems findOne doesnt work with gt operators (Or at least not the way I am using the operator)
In the core code, I found this:

public function findOne($shortName, array $where, $with = null){
    $finder = $this->getFinder($shortName);
    $finder->where($where); // this is thus: ['created_date' => ['>', $expiredTime]], which is not the same as : 'created_date', '>', $expiredTime
    if ($with)
    {
        $finder->with($with);
    }
    return $finder->fetchOne();
}

I'm not really sure why, but the finder->fetchOne works as a work around

 

[Jeremy P]

The column should be part of the array and not a key when using operators:

\XF::em()->findOne(
    \Tenants\ToolsAdmin\Entity\ProjectInviteEntity::class,
    ['created_date', '>', $expiredTime]
);