Converting MongoDB query to jenssegers/laravel-mongodb

Question

How would you write a query like this

db.collection.find({$expr: {$lte: [{ $mod: [ '$created_at', 3600 ] }, 59]}});

using the jenssegers/laravel-mongodb extension

I couldn't find a way to write that query using the jenssegers/laravel-mongodb extension, so I fetched the records and implemented the logic to filter them myself in the code. — user3010617
– user3010617, Commented Jul 20, 2018 at 14:45

Dario Rusignuolo · Accepted Answer · 2018-07-20 17:48:45Z

1

use the raw expression following the documentation

YourModel::whereRaw([
            '$expr' => [
                '$lte' => [
                    [
                        '$mod' => [
                            '$created_at', 3600
                        ],
                        59
                    ]
                 ]
            ]
        ])->get();

edited Jul 20, 2018 at 17:48

answered Jul 20, 2018 at 17:32

Dario Rusignuolo

2,2067 gold badges39 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting MongoDB query to jenssegers/laravel-mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related