[Symfony][SF2][Symfony2] createNativeQuery + join i subquery -problem z mapowaniem Opcje

[adamantd]

Witam, nie mogę sobie poradzić ze zmapowaniem Joina:

[PHP] pobierz, plaintext 
 
$rsm = new ResultSetMapping;
        $rsm->addEntityResult('AccountClientBundle:SearchQuestionConnect', 'c');
        $rsm->addFieldResult('c', 'c_id', 'id');
        $rsm->addFieldResult('c', 'c_distance', 'distance');
        $rsm->addJoinedEntityResult('AccountClientBundle:SearchQuestionConnectPriceComment', 'sq', 'c', 'search_question_connect_id'); //Z TYM JEST CAŁY CZAS PROBLEM
        $rsm->addFieldResult('sq', 'sq_id', 'id');
        $rsm->addMetaResult('sq', 'sq_search_question_connect_id', 'search_question_connect_id');
 
 
        $q = $this->getEntityManager()->createNativeQuery("
              SELECT
              c.id AS c_id,
              c.distance AS c_distance,
              sq.id AS sq_id,
              sq.search_question_connect_id AS sq_search_question_connect_id
              FROM search_question_connects AS c
              JOIN (SELECT * FROM search_question_connect_price_comments ORDER BY created_at DESC) AS sq ON (sq.search_question_connect_id=c.id)
              WHERE
              c.search_id = {$searchId}
              AND c.status_bidder = 2
              GROUP BY c.id
              ORDER BY sq.created_at DESC
              ", $rsm);
        $r = $q->getResult();
 
 
[PHP] pobierz, plaintext 

Ciągle wyskakuje mi:

[PHP] pobierz, plaintext 
Notice: Undefined index: search_question_connect_id
[PHP] pobierz, plaintext 

bez wzgledu na to co podam jako ostatni parametr dla

[PHP] pobierz, plaintext 
$rsm->addJoinedEntityResult()
[PHP] pobierz, plaintext 

to zawsze jest ten sam błąd tylko zmienia się oczywiście

[PHP] pobierz, plaintext 
Undefined index w zależności od tego jaka jest wartość tego parametru
[PHP] pobierz, plaintext 

Jeżeli usunę 3 ostatnie linijki

[PHP] pobierz, plaintext 
$rsm->
[PHP] pobierz, plaintext 

to zapytanie wykonuje się tak jak tego oczekuję -potrzebuję jednak dołączyć wyniki drugiej tabeli

Będe wdzięczny za pomoc

[prz3kus]

Pole search_question_connect_id istnieje w klasie entity?

[adamantd]

[PHP] pobierz, plaintext 
/**
     * @ORM\ManyToOne(targetEntity="SearchQuestionConnect", inversedBy="searchQuestionConnectPriceComments")
     * @ORM\JoinColumn(name="search_question_connect_id", referencedColumnName="id",onDelete="CASCADE")
     **/
private $searchQuestionConnect;
[PHP] pobierz, plaintext 

[prz3kus]

No to w joinie chyba trzba podać searchQuestionConnect, a nie search_question_connect_id

[adamantd]

Testuje -nie pomaga

[PHP] pobierz, plaintext 
Notice: Undefined index: searchQuestionConnect
[PHP] pobierz, plaintext 

[prz3kus]

$rsm->addMetaResult('sq', 'sq_search_question_connect_id', 'search_question_connect_id');

tutaj tez trzeba zmienic

[adamantd]

Chciałbym ale niestety -wszystkie możliwe kombinacje po kolei i nic ...

[PHP] pobierz, plaintext 
 
$rsm->addJoinedEntityResult('AccountClientBundle:SearchQuestionConnectPriceComment', 'sq', 'c', 'searchQuestionConnect');
        $rsm->addFieldResult('sq', 'sq_id', 'id');
//        $rsm->addMetaResult('sq', 'sq_search_question_connect_id', 'search_question_connect_id');
        //$rsm->addMetaResult('sq', 'sq_searchQuestionConnect', 'search_question_connect_id');
        $rsm->addMetaResult('sq', 'searchQuestionConnect', 'search_question_connect_id');
 
[PHP] pobierz, plaintext 

tutaj też:

[PHP] pobierz, plaintext 
 
 $q = $this->getEntityManager()->createNativeQuery("
              SELECT
              c.id AS c_id,
              c.distance AS c_distance,
              c.offer_id AS c_offer_id,
              sq.id AS sq_id,
              sq.search_question_connect_id AS searchQuestionConnect
 
[PHP] pobierz, plaintext 

[prz3kus]

Poczytaj dokumentacje(o ile jeszcze nie zrobikles) ciągle źle podmieniasz

Tak to powinno wyglądać:

[PHP] pobierz, plaintext 
$rsm->addJoinedEntityResult('AccountClientBundle:SearchQuestionConnectPriceComment', 'sq', 'c', 'searchQuestionConnect');
        $rsm->addFieldResult('sq', 'sq_id', 'id');
//        $rsm->addMetaResult('sq', 'sq_search_question_connect_id', 'search_question_connect_id');
        //$rsm->addMetaResult('sq', 'sq_searchQuestionConnect', 'search_question_connect_id');
        $rsm->addMetaResult('sq', 'search_question_connect_id', 'searchQuestionConnect');
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$q = $this->getEntityManager()->createNativeQuery("
              SELECT
              c.id AS c_id,
              c.distance AS c_distance,
              c.offer_id AS c_offer_id,
              sq.id AS sq_id,
              sq.search_question_connect_id AS search_question_connect_id
[PHP] pobierz, plaintext