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 a94638e38e5aa1c67e2f9d8a9d27d10f14493ce2 Author: Sylvain Bavencoff <bavencoff@codelutin.com> Date: Tue May 26 15:28:42 2015 +0200 refs #7146 : Liste des activités avec des comments (71.4 ms ==> 26.535 ms) --- observe-business/src/main/filters/observe-reports.properties | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/observe-business/src/main/filters/observe-reports.properties b/observe-business/src/main/filters/observe-reports.properties index 434dda1..ce8c88d 100644 --- a/observe-business/src/main/filters/observe-reports.properties +++ b/observe-business/src/main/filters/observe-reports.properties @@ -29,13 +29,13 @@ report.activityWithComment.description=Afficher les activit\u00e9s avec comment report.activityWithComment.columns=Jour - Heure observation, Latitude, Longitude, Activit\u00e9, Commentaire report.activityWithComment.request.1=0,0|row|\ Select concat(day(r.date), '/', month(r.date), '/', year(r.date), ' ', hour(a.time), ':', minute(a.time)), a.latitude, a.longitude, ab.label2, a.comment \ - From TripSeineImpl m, RouteImpl r, ActivitySeineImpl a, VesselActivitySeineImpl ab \ + From TripSeineImpl m \ + Join m.route r \ + Join r.activitySeine a \ + Join a.vesselActivitySeine ab \ Where \ m.id = :tripId \ - and r in elements(m.route) \ - and a in elements(r.activitySeine) \ and a.comment is not null \ - and ab = a.vesselActivitySeine \ Order By r.date, a.time ################################################################################ -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@list.forge.codelutin.com>.