I'm using Laravel-MongoDB from jenssegers. Now I wish to create a custom query. By documentation, I need to use the RAW method.
$model = User::whereRaw(['$limit : 5'])->get();
dd($model);
Why my result is empty?
Collection {#235 ▼
#items: []
}
Asked
Active
Viewed 2,575 times
1
Rubens Mariuzzo
- 28,358
- 27
- 121
- 148
lolalola
- 3,773
- 20
- 60
- 96
-
1I'd start installing the laravel-debug bar and looking at the queries performed. – tacone Dec 06 '15 at 23:48
-
the docs seem to say you can use the regular builder methods like take() and skip() – lagbox Dec 07 '15 at 00:32
-
@lolalola, what version of Laravel are you using? – Rubens Mariuzzo Dec 07 '15 at 18:15
-
@Rubens Mariuzzo>Laravel Framework version 5.1.19 (LTS), MongoDB vewrsion 3.0.6 – lolalola Dec 07 '15 at 21:55
1 Answers
0
The docs for Moloquent's whereRaw method expect a complete PHP array instead of passing a string of JSON object inside a PHP array.
$model = User::whereRaw(['$limit' => '5'])->get();
Give it a try, and let me know if it helps.
Update
The docs also list that the following is possible:
$model = User::take(5)->get();
Rubens Mariuzzo
- 28,358
- 27
- 121
- 148
-
-
I need create native MongoDB query, doesn't use jenssegers query builder. – lolalola Dec 07 '15 at 22:29
-
But, using Moloquent#take method, will not translate to native MongoDB query? Have you checked the generated query? Try: `dd(User::take(5)->toSql())` and see what you get. – Rubens Mariuzzo Dec 07 '15 at 22:43