This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository tutti. See http://git.codelutin.com/tutti.git commit 5ff652aa3a3825cd53d77e7bb8294bc86dba46ca Author: Tony CHEMIT <chemit@codelutin.com> Date: Sun Feb 15 14:29:32 2015 +0100 fix queries --- tutti-persistence/src/main/resources/queries-failsafe.hbm.xml | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/tutti-persistence/src/main/resources/queries-failsafe.hbm.xml b/tutti-persistence/src/main/resources/queries-failsafe.hbm.xml index d4aefb1..0367f32 100644 --- a/tutti-persistence/src/main/resources/queries-failsafe.hbm.xml +++ b/tutti-persistence/src/main/resources/queries-failsafe.hbm.xml @@ -1158,6 +1158,7 @@ vrp.registrationCode AS nationalRegistrationCode, vrp.internationalRegistrationCode as internationalRegistrationCode, vf.name AS vesselName, + v.vesselType.id AS vesselTypeId, v.status AS status FROM VesselImpl v @@ -1186,6 +1187,7 @@ vrp.registrationCode AS nationalRegistrationCode, vrp.internationalRegistrationCode as internationalRegistrationCode, vf.name AS vesselName, + v.vesselType.id AS vesselTypeId, v.status AS status FROM VesselImpl v @@ -1213,13 +1215,14 @@ vrp.registrationCode AS nationalRegistrationCode, vrp.internationalRegistrationCode as internationalRegistrationCode, vf.name AS vesselName, + v.vesselType.id AS vesselTypeId, v.status AS status FROM VesselImpl v INNER JOIN v.vesselRegistrationPeriods AS vrp LEFT OUTER JOIN v.vesselFeatures AS vf WHERE - v.internationalRegistrationCode = :vesselInternationalRegistrationCode + vrp.internationalRegistrationCode = :vesselInternationalRegistrationCode AND v.status.code IN (:statusValidCode, :statusTemporaryCode) AND NOT(coalesce(vrp.endDateTime, '2999-12-31 00:00:00') < coalesce(:refDate,sysdate) OR vrp.vesselRegistrationPeriodPk.startDateTime > coalesce(:refDate,sysdate) @@ -1349,7 +1352,7 @@ FROM PersonImpl p WHERE p.firstname = :personFirstName - p.lastname = :personLastName + AND p.lastname = :personLastName AND p.status.code IN (:statusValidCode, :statusTemporaryCode) ]]> <query-param name="personFirstName" type="java.lang.String"/> -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.