protected function selectQuery(array $where = []) { $query = parent::selectQuery($where); // Select 'key' too $query->select($this->getTable() . '.*', 'form_attributes.key')->join('form_attributes')->on('form_attribute_id', '=', 'form_attributes.id'); return $query; }
protected function selectQuery(array $where = []) { $query = parent::selectQuery($where); // Join to messages and load message id $query->join('messages', 'LEFT')->on('posts.id', '=', 'messages.post_id')->select(['messages.id', 'message_id'], ['messages.type', 'source']); return $query; }
/** * Override selectQuery to enforce filtering by search=0/1 */ protected function selectQuery(array $where = []) { $query = parent::selectQuery($where); $query->where('search', '=', (int) $this->savedSearch); return $query; }