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);
}
