$this->_extra_col = array('office_country_name');
$this->_distinct= 'office_id_country&cols=office_id_country,office_id_country_name';
//then the query should be _distinct=office_id_country&cols=office_id_country,office_id_country_name
- $p = DB_DataObject::factory('Person');
- $p->whereAdd("office_id > 0");
- $p->selectAdd();
- $p->selectAdd("DISTINCT(office_id) as office_id");
- $officeIds = $p->fetchAll('office_id');
- $this->whereAddIn($tn.'.id', $officeIds, 'INT');
- $this->selectAdd();
- $this->selectAdd("DISTINCT({$tn}.country) as country");
- $this->joinAddCountryWithPerson();
+// $p = DB_DataObject::factory('Person');
+// $p->whereAdd("office_id > 0");
+// $p->selectAdd();
+// $p->selectAdd("DISTINCT(office_id) as office_id");
+// $officeIds = $p->fetchAll('office_id');
+// $this->whereAddIn($tn.'.id', $officeIds, 'INT');
+// $this->selectAdd();
+// $this->selectAdd("DISTINCT({$tn}.country) as country");
+// $this->joinAddCountryWithPerson();
}
}