Get Alias using ResultSetMapping

I have a query that using latitude and longitude, gets me the records that are close to other latitude and longitude. In the query I get the distance but I don't know how to return it. This is my code:

public function findNearUsers($lon, $lat, $dist = 25){

        $rsm = new ResultSetMapping;


        $rsm->addEntityResult('Entities\Users', 'l');
        $rsm->addFieldResult('l', 'id', 'id');
        $rsm->addFieldResult('l', 'name', 'name');
        $rsm->addFieldResult('l', 'birthDay', 'birthDay');
        $rsm->addFieldResult('l', 'gender', 'gender');

        $query = $this->_em->createNativeQuery(
                "SELECT l.id, l.name, l.birthDay, l.gender, SQRT(
    POW(69.1 * (latitude - (?)), 2) +
    POW(69.1 * ((?) - longitude) * COS(latitude / 57.3), 2)) AS distance
    FROM users l
            HAVING distance < (?)
            ORDER BY distance", $rsm
        );

        $query->setParameter(1, $lat);
        $query->setParameter(2, $lon);
        $query->setParameter(3, $dist);

        return $query->getResult();
    }

As you can see I calculate the distance and have in the query as as distance . How can I return distance? Thanks!

Answers


For anybody that has the same problem, I don't know if it was a workaround, but adding the variable to my entity worked.


Need Your Help

How to call AJAX function after form elements are cloned using jQuery?

jquery ajax clone

I have a dynamic form that can be cloned, using the SheepIt! plugin to clone my form elements. My form has a dynamic set of dropdown boxes, where the second dropdown box display a set of values ba...

Is there a way to get jadclipse working with Eclipse 3.4?

java eclipse plugins eclipse-plugin jad

I'm a big fan of the Jadclipse plugin and I'd really like to upgrade to Eclipse 3.4 but the plugin currently does not work. Are there any other programs out there that let you use jad to view sourc...