SilverStripe ORM where clause on relations and its count

user_4675736 0
Viewed 432

I am working on a SilverStripe project. Now I am querying the data. What I am trying to do is getting all the records running where clause on the count of its relations.

The below query will get all the NewsPage records. NewsPage has many blogs. So, they have a one-to-many relationship:

NewsPage::get();

So if I want to get all the blogs on the news page, I have to do this:

$newPage->BlogPosts()

Now, what I am trying to do is that I am trying to get all the news pages that have more than one blog post:

Something like this arbitrary code

$newPage->where('BlogPosts.Count', '>', 1)->get();

How can I achieve this?

silverstripe-4 silverstripe
1 Answers

In SilverStripe 4 we can filter on a $has_many or $many_many relationship count as follows:

NewsPage::get()->filter([
    'BlogPosts.Count():GreaterThan' => 1
]);

For this to work NewsPage must have a $has_many or $many_many relationship to BlogPost called BlogPosts.

user_17157590
Related