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