7938 Posts in 1541 Topics by 945 members
|Go to End|
21 August 2009 at 3:16pm
I'm trying to get some random products from a DOM, however I want them to only be from currently published pages.
RIght now I have this:
public function getSpecialItems($limit)
//DataObject::get($obj, $filter, $sort, $join, $limit);
return DataObject::get("SpecialItem","SpecialHolderID != 5","RAND()","",$limit);
Because my SpecialHolder with ID 5 isn't published and I don't want the results to include it. I'd rather this be more automatic and not hard coded. Any thoughts?
22 August 2009 at 3:27am
You need to use a join.
"INNER JOIN `SpecialHolder` ON `SpecialHolder`ID = SpecialItem.SpecialHolderID",
It should automatically add the "_Live" suffix to SpecialHolder table, which will nullify the SpecialItem records that aren't attached to a _Live table.
Probably not the best way to do that, though.
|Go to Top|