protected function _buildQueryJoins(KDatabaseQueryInterface $query) { $query->join(array('c' => 'docman_categories'), 'tbl.docman_category_id = c.docman_category_id') ->join(array('viewlevel' => 'viewlevels'), '(CASE tbl.access WHEN -1 THEN COALESCE(c.access, 1) ELSE tbl.access END) = viewlevel.id'); parent::_buildQueryJoins($query); }
protected function _buildQueryJoins(KDatabaseQueryInterface $query) { $query->join(array('viewlevel' => 'viewlevels'), 'tbl.access = viewlevel.id'); parent::_buildQueryJoins($query); }