I was wondering what would be the best way of getting all records of a model with at least one of an associated model, in a one-to-many relationship.
In this particular example, I'm trying to get a list of all news categories that contain at least one article, filtering out empty categories.
Could I streamline the following in any way using DataObject?
DataObject::get("NewsCategory", "EXISTS (SELECT 1 FROM Article WHERE SiteTree_Live.ID = NewsCategoryID)")
(NewsCategory extends Page, SiteTree)