hi
i need to construct sql query in SilverStripe but i dont know how
i have two tables
EnToursPage
- ID
- ExtraContent
(more ...)
and
EnToursHolder
- ID
- HighlightTour
- HighlightYES
in EnToursHolder (in CMS) i have dropdownlist where i can choose which EnToursPage i want to highlight
then in template i want to show ID,Ttile,Content of highlights product (EnToursPage)
so i need to do something like this
SELECT * FROM EnToursHolder, EnToursPage WHERE EnToursHolder.HighlightTourID = EnToursPage.ID AND EnToursHolder.HighlightYES = 1;
how to do it by DataObject::get ?
$doSet = DataObject::get(
$callerClass = "",
$filter = "",
$sort = "",
$join = "",
$limit = ""
);
return $doSet;