/** * {@inheritdoc} */ public function getSearch() { return sprintf('%s LIKE :search OR (%s is NULL AND %s LIKE :search)', $this->case1->getSelect(), $this->case1->getSelect(), $this->case2->getSelect()); }
/** * {@inheritdoc} */ public function getSelect() { return sprintf('CASE WHEN %s IS NOT NULL THEN %s ELSE %s END', $this->case1->getSelect(), $this->case1->getSelect(), $this->case2->getSelect()); }