Bertrand Zuchuat wrote:
> Hello,
>
> Check with this:
>
> $q = Doctrine_Query::create()
> ->select('j.*, (j.endtime - j.starttime) as duration, s.jobstatuslong,
> c.name, p.name, f.*')
> ->from('Job j')
> ->leftJoin('j.Status s')
> ->leftJoin('j.Client c')
> ->leftJoin('j.Pool p')
> ->leftJoin('j.Fileset f')
> ->where("j.endtime > ?", $last1day)
> ->addWhere("j.jobstatus IN ('T', 'E', 'e', 'f', 'A')")
> ->orderBy('j.starttime, j.jobid')
>
> Bertrand
>
Nothing, I get this error insted:
500 | Internal Server Error | Doctrine_Table_Exception
Unknown relation alias Status
Cheers
--
Ing. Reynier Pérez Mira
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
