查询与子表上的where子句的关系

Question

I have been using the has method to query the existence of data in a related table and that is working just fine. Using the code example on the Laravel web site, you can do the following to get any post that has comments associated with it.

$posts = Post::has('comments')->get();

What I would like to be able to do, as an example, is query for any post which has comments from the last thirty days. Since the has method only has the ability to count related rows I am not sure of a good way to do this.

Answer 1

From the Laravel 4 Documentation:

 $posts= Post::with(array('comments' => function($query)
 {
    $query->where('published', '>=', 'date- 1 month'); //look date functions up
 }))->get();

See Eager Load Constraints under laravel 4 documentation