function getQuery() { $query = parent::getQuery(); $query->select[] = "CASE WHEN \"{$this->manyManyParentClass}ID\" IS NULL THEN '0' ELSE '1' END AS \"Checked\""; $query->groupby[] = "\"{$this->manyManyParentClass}ID\""; // necessary for Postgres return $query; }
function getQuery() { $query = parent::getQuery(); $query->select[] = "CASE WHEN \"{$this->manyManyParentClass}ID\" IS NULL THEN '0' ELSE '1' END AS Checked"; return $query; }
function getQuery() { $query = parent::getQuery(); $query->select[] = "IF(`{$this->manyManyParentClass}ID` IS NULL, '0', '1') AS Checked"; return $query; }