This is an automated email from the git hooks/post-receive script. New commit to branch feature/7146 in repository observe. See http://git.codelutin.com/observe.git commit 72b755fcb173b86f453f03ad8af6d9367d2e346c Author: Sylvain Bavencoff <bavencoff@codelutin.com> Date: Tue May 26 15:55:39 2015 +0200 refs #7146 : Nombre de calées et captures journalières d'une marée (33.262 ms ==> 11.52 ms) --- observe-business/src/main/filters/observe-reports.properties | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/observe-business/src/main/filters/observe-reports.properties b/observe-business/src/main/filters/observe-reports.properties index 7464814..740f352 100644 --- a/observe-business/src/main/filters/observe-reports.properties +++ b/observe-business/src/main/filters/observe-reports.properties @@ -64,13 +64,13 @@ report.dailySetAndCatch.description=Afficher le nombre de cal\u00e9es et les cap report.dailySetAndCatch.columns=Jour observation,Nombre de cal\u00e9es ,Captures thon report.dailySetAndCatch.request.1=0,0|row|\ Select concat(day(r.date), '/', month(r.date), '/', year(r.date)), Count(distinct a), Sum(ct.catchWeight) \ - From TripSeineImpl m, RouteImpl r, ActivitySeineImpl a \ - left join a.setSeine.targetCatch as ct \ + From TripSeineImpl m \ + Join m.route r \ + Join r.activitySeine a \ + Join a.setSeine s \ + left join s.targetCatch as ct \ Where \ m.id = :tripId \ - and r in elements(m.route) \ - and a in elements(r.activitySeine) \ - and a.setSeine is not null \ Group By r.date \ Order By r.date -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@list.forge.codelutin.com>.