protected function _buildQueryColumns(KDatabaseQueryInterface $query)
{
parent::_buildQueryColumns($query);
$query->columns('c.title AS category_title')
->columns('c.slug AS category_slug')
->columns('c.access AS category_access')
->columns('c.enabled AS category_enabled')
->columns('CONCAT_WS(\'-\', tbl.docman_document_id, tbl.slug) AS alias')
->columns('tbl.access AS access_raw')
->columns('(CASE tbl.access WHEN -1 THEN COALESCE(c.access, 1) ELSE tbl.access END) AS access')
->columns('viewlevel.title AS access_title')
->columns('IF(tbl.publish_on = 0, tbl.created_on, tbl.publish_on) AS publish_date')
->columns('GREATEST(tbl.created_on, tbl.modified_on) AS touched_on')
;
}
protected function _buildQueryColumns(KDatabaseQueryInterface $query)
{
$query->columns(array('access_title' => 'viewlevel.title'));
parent::_buildQueryColumns($query);
}
