Details
Description
<?php /** * Service * * @Entity(repositoryClass="App_Model_Repository_Si_Service") * @Table(name="service") */ class App_Model_Entities_Si_Service { /** * @var int * * @Id * @GeneratedValue(strategy="SEQUENCE") * @Column(name="pk", type="integer") */ public $pk; /** * Service parent * @var App_Model_Entities_Si_Service * * @ManyToOne(targetEntity="App_Model_Entities_Si_Service", cascade={"all"}, inversedBy="service") * @JoinColumn(name="pk_service", referencedColumnName="pk") */ private $service; /** * Returns an App_Model_Entities_Si_Service that represents the service * * @return App_Model_Entities_Si_Service */ public function getService(){ return $this->service; } /** * Set an App_Model_Entities_Si_Service that represents a service * * @param App_Model_Entities_Si_Service $newService */ public function setService($newService){ $this->service = $newService; } }
$service = $this->service('Service_Type', true); $serviceType = $service->findOneBy(array('code' => 'service')); $service = $this->service('Service', true); $services = $service->findBy( array('serviceType' => $serviceType->getPk()), array('service' => 'ASC') );
Using orderBy parameter of EntityRepository::findBy() with Foreign Key do not work.
An Unrecognized field error occured.
Of course, i can use DQL but i think this function should work with mapping.
Thank you in advance