Hi,
I am replacing all the Pages using DataObjects with DataList as a 3.1 Upgradation process.
$Members = Member::get()->filter(array("Group.ID" => $Group->ID))->leftjoin("Group_Members","\"Group_Members\".\"MemberID\" = \"Member\".\"ID\"","Group_Members")->leftjoin("Group","\"Group\".\"ID\" = \"Group_Members\".\"GroupID\"","Group")->sort('Email');
When I used Join Columns(array("Group.ID" => $Group->ID)) in filter it does not work.
I currently modified it as below to make it work
DataObject::get("Member", $Filter, 'Email ASC')->leftjoin("Group_Members","\"Group_Members\".\"MemberID\" = \"Member\".\"ID\"","Group_Members")->leftjoin
("Group","\"Group\".\"ID\" = \"Group_Members\".\"GroupID\"","Group");
How do I convert below query to DataList?
$Filter = "`Group`.`ID` = " . $Group->ID;
$Join = " LEFT JOIN `Group_Members` ON `Group_Members`.`MemberID` = `Member`.`ID`
LEFT JOIN `Group` ON `Group`.`ID` = `Group_Members`.`GroupID`" ;
$Members = DataObject::get('Member', $Filter, 'Email ASC', $Join);