[Request] Allow other query methods in Eloquent eager loading closure

[johnnncodes]

Currently, we can only use WHERE clauses in closures when eager loading. Like:

$users = User::with(array('posts' => function($query)
{
$query->where('title', 'like', '%first%');

}))->get();

Maybe allowing ORDERBY, LIMIT, OFFSET etc... will be a good idea? So we will have more control when eager loading something using Eloquent.

Something like:

$users = User::with(array('posts' => function($query)
{
$query->orderBy('created_at', 'desc');

}))->get();

[franzliedke]

That's a huge +1 from me.

[djtarazona]

+1

[yuters]

👍

[billmn]

👍

[juukie]

Could be usefull sometimes! +1

[Meroje]

👍

[stevemo]

[AustinW]

👍

[ghost]

+1

[asifrust]

+1

[jasonlewis]

👍

[JonoB]

+1

Btw, in the meantime, you can specify these arguments in the relationship if you wish.

[frankmayer]

👍

[nicholasruunu]

👍

[Dalamar]

👍

[ghost]

👍

[Globegitter]

[ghost]

@JonoB would you mind showing us an example of your workaround?

[tlgreg]

@falzhobel

    public function posts()
    {
        return $this->hasMany('Post')->orderBy('created_at', 'desc');
    }

And a 👍

[JonoB]

@falzhobel As @tlgreg demonstrated, you can have any clauses (orderBy, where, etc) in the relationship. Its not workable if you need dynamic clauses, but it works just fine if your clauses are always static.

[ghost]

Thanks guys :)

[champiewebfolio]

+1

[taylorotwell]

What makes you guys think this doesn't already work? It does and always has in Laravel 4.

[daylerees]

💃

[jcldavid]

✌️

[tlgreg]

Now that's just lol. Nice! 🍶

[yuters]

I +1'd this without taking the time to try it, but now I have and as @taylorotwell said, it works just like this in Laravel4.

We're just a bunch of gullible sheeps ! Haha

[ghost]

Hahaha, indeed we are just a bunch sheeps. Thanks for the heads up @taylorotwell

[johnnncodes]

Lol. This really made me laugh. :)) thank you so much @taylorotwell and sorry for opening this feature request :))

[asifrust]

LoL :D Another Sheep here. thanx @taylorotwell

On Sat, Jan 19, 2013 at 5:02 AM, John Kevin M. Basco <
[email protected]> wrote:

Lol. This really made me laugh. :)) thank you so much @taylorotwellhttps://github.com/taylorotwelland sorry for opening this feature request :))

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/55#issuecomment-12444967.