This is an automated email from the git hooks/post-receive script. New commit to branch feature/8114 in repository tutti. See http://git.codelutin.com/tutti.git commit bf6087044082a4c169e427e8353f3052f4a5296f Author: Tony CHEMIT <chemit@codelutin.com> Date: Sat Mar 12 07:46:06 2016 +0100 Ajout de nouvelles requetes pour récupérer toutes les observation individuelles d'un trait (pour la suppression) --- .../src/main/resources/queries-failsafe.hbm.xml | 20 ++++++++++++++++++-- 1 file changed, 18 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 29c80ba..4d1c4a0 100644 --- a/tutti-persistence/src/main/resources/queries-failsafe.hbm.xml +++ b/tutti-persistence/src/main/resources/queries-failsafe.hbm.xml @@ -511,7 +511,7 @@ <query-param name="fishingOperationId" type="java.lang.Integer"/> </query> - <!-- [DAT-23] Get all fishing operations samples for a given batch --> + <!-- [DAT-23-1] Get all fishing operations samples for a given batch --> <query cacheable="true" name="allFishingOperationSamplesForBatch"> <![CDATA[ SELECT @@ -530,7 +530,7 @@ <query-param name="batchId" type="java.lang.Integer"/> </query> - <!-- [DAT-23-1] Get all fishing operations samples ids for a given batch --> + <!-- [DAT-23-2] Get all fishing operations samples ids for a given batch --> <query cacheable="true" name="allFishingOperationSampleIdsForBatch"> <![CDATA[ SELECT @@ -545,6 +545,22 @@ <query-param name="batchId" type="java.lang.Integer"/> </query> + <!-- [DAT-23-3] Get all fishing operations samples ids --> + <query cacheable="true" name="allFishingOperationSampleIds"> + <![CDATA[ + SELECT + s.id AS id + FROM + SampleImpl s + WHERE + s.fishingOperation.id= :fishingOperationId + AND s.batch IS NOT NULL + ORDER BY + s.id + ]]> + <query-param name="fishingOperationId" type="java.lang.Integer"/> + </query> + <!-- [DAT-24] Get sample measurements --> <query cacheable="true" name="sampleMeasurements"> <![CDATA[ -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.