doujiang2020 2015-01-14 06:03
浏览 57

在Doctrine中使用ResultSetMapping

I have a query like this:

  $query = "select run_record_detail.id from
            (select max(id) as run_record_id from run_record  where delete_flag=0 group    by test_run_id) rr
               inner join 
            run_record_detail
            on rr.run_record_id = rr.run_record_id
            where delete_flag=0 and test_case_id IN (:ids)";

    $rsm = new \Doctrine\ORM\Query\ResultSetMapping();
    $rsm->addEntityResult('\Test\Entity\RunRecordDetail', 'run_record_detail');
    $rsm->addFieldResult('run_record_detail', 'id', 'id');
    $query = $this->getEntityManager()->createNativeQuery($query, $rsm);
    $query->setParameter('ids', $testCaseIdArray);
    $result = $query->getResult();

I am trying to use ResultsetMapping to bind run_record_detail to RunRecordDetail object. I want RunRecordDetail object in the output. But I am getting only its id(as I have selected ). Please help me getting this object. I am following Doctrine doc http://doctrine-orm.readthedocs.org/en/latest/reference/dql-doctrine-query-language.html

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭
    • ¥15 2020长安杯与连接网探
    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么