Did you try debugging this? I don't want to sound too harsh, but if you put this in any phpunit test and step through with a debugger, it's trivial to find this sort of problem out...
Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 16 September 2014 14:29, Sandro Cândido <[email protected]> wrote: > > > Em terça-feira, 9 de setembro de 2014 15h37min53s UTC-3, Sandro Cândido > escreveu: > >> Hi all >> >> Help how to fill column alias( *number_document* ) receive data column >> that is not part of the entity to return object correctly without error. >> The SQL executed correctly the problem is with in populate entitiy with >> column dinamic. >> >> I am not knowing how to apply ( *addMetaResult* and >> *setDisciminatorColumn* perhaps not even the case I doing wrong way ) to >> the case I need Example below >> >> Please help :( >> >> $rsm = new \Doctrine\ORM\Query\ResultSetMapping(); >> $rsm->addEntityResult('Document', 'd'); >> $rsm->addMetaResult('d', '*number_document*', '*number_document*'); >> // discriminator column >> $rsm->setDiscriminatorColumn('d', '*number_document*'); >> >> $rsm->addJoinedEntityResult('Document_interested' , 'i', 'd', >> 'interested'); >> $rsm->addJoinedEntityResult('Documento_type_interested' , 't', >> 'd', 'type_document'); >> >> $sql = "select distinct d.id, >> case when >> d.number_office is null then >> d.information_number_document >> else >> to_char(d.number_office,'0000') >> end as *number_document* >> from >> document d left join documento_type_interested t on >> (t.document_id = d.id) >> left join document_interested as i on >> (d.document_interested_id = i.id) >> where >> t.type != ? and >> d.stat_document = ? >> limit 5"; >> >> $query = $this->em->createNativeQuery($sql, $rsm); >> $query->setParameter(1, '0'); >> $query->setParameter(2, 'T'); >> >> $result_obj = $query->getResult(); >> var_dump( $result_obj ); >> >> Error: >> A PHP Error was encountered >> >> Severity: Notice >> >> Message: Undefined index: 01/03/1209-FT >> >> Filename: Hydration/ObjectHydrator.php >> >> Line Number: 234 >> >> Fatal error: Uncaught exception 'ReflectionException' with message 'Class >> does not exist' in /myproject/sis/application/ >> third_party/Doctrine/Common/Persistence/Mapping/RuntimeReflectionService.php >> on line *73* >> > > Nobody helps everyone in the community for this event? > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
