Time condition in MongoDb ActiveRecord find()->where() statement

Yii 2.0 General Discussions
1

I tried:


$tweets = Tweet::find()->where(['<=', 'tweet_time', new \MongoDate()])->all();

But it throws:


Invalid Parameter – yii\base\InvalidParamException

Found unknown operator in query: <=

How to express it properly?

Thanks.

2

try

$tweets = Tweet::find()->where(‘tweet_time<=:t’, [’:t’=>new \MongoDate()])->all();

not checked, but it may work

3

no, it doesn’t

4

any help?

5

You should use MongoDB conditional operators:




$tweets = Tweet::find()->where(['tweet_time' => ['$lte' => new \MongoDate()]])->all();
6

Thanks, Paul!