Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions /

Returning Categories with at least one Article: better, prettier way?


Reply


559 Views

Avatar
gcoderre

Community Member, 5 Posts

4 February 2011 at 11:40am

Edited: 04/02/2011 11:43am

Hi,

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)