CODEWITHSUNDEEP
silverstripesilverstripe-4
Wai Yan Hein
Wai Yan Hein

Reputation: 14791

SilverStripe ORM where clause on relations and its count

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?

Upvotes: 3

Views: 1014

Answers (1)

3dgoo
3dgoo

Reputation: 15794

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.

Upvotes: 4

Related Questions