Column subquery

Hi i'm tying to perform a subquery in a column, its works fine, but i cannot assign it to any model with the c. do not works, if only metas work but i cannot access from any object only direct $row->metas i would like to access like it $row->c->metas

->columns( array( 'c.','m.', 'm2.*', 'c.metas' => $this->groupConcat(array('chave' => 'valor'), 'FROM \Apps\Models\ConteudosMeta as cm where cm.id_conteudo =')));


What does groupConcat makes?

edited Jul '15


$select = $this->getModelsManager()->createBuilder() ->addFrom('\Apps\Models\Conteudos', 'c') ->leftJoin('\Apps\Models\Midias', ' = c.idmidias', 'm') ->leftJoin('\Apps\Models\Midias', ' = c.iddestaque', 'm2') ->columns( array( 'c.','m.', 'm2.*', 'metas' => $this->groupConcat(array('chave' => 'valor'), 'FROM \Apps\Models\ConteudosMeta as cm where cm.id_conteudo =')));

Group concat make a JSON

"(SELECT CONCAT('{',GROUPCONCAT(CONCAT('"',chave,'":"',IFNULL(valor, 0),'"')),'}' ) FROM \Apps\Models\ConteudosMeta as cm where cm.idconteudo ="

Its return an JSON $model->metas


The query is working fine, however $model->metas, i wish to access from Conteudos model, like $model->c->metas

I already tried to use c.metas => sql but does not work,

It's possible from a Model get all result from a row example $model->c->m->titulo? get title from midias

edited Jul '15

Probably you can't use a qualified identifier as alias. What about?

->columns( array( 'c.','m.', 'm2.*', 'meta' => $this->groupConcat(array('chave' => 'valor'), 'FROM \Apps\Models\ConteudosMeta as cm where cm.id_conteudo =')));

Then you can access it as:


This was what i did before, but ok awnser my question! its not possible!