Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: e2af824e by Tony Chemit at 2020-07-17T14:13:49+02:00 Les rapports FOB ne fonctionnent pas - Closes #1581 - - - - - 1 changed file: - services/src/main/resources/observe-reports.properties Changes: ===================================== services/src/main/resources/observe-reports.properties ===================================== @@ -137,9 +137,9 @@ report.fobUsageMinimal.repeatVariable.typeObjetId=java.lang.String|\ Where standardCode is not null \ And standardCode != '' \ And (Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ @@ -156,70 +156,70 @@ report.fobUsageMinimal.request.1.repeat=typeObjetId|column # rencontres + peches report.fobUsageMinimal.request.2=1,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' \ - and (dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#9' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#10' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#3') + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \ + and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') report.fobUsageMinimal.request.2.repeat=typeObjetId|column # rencontres - peches report.fobUsageMinimal.request.3=2,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' -and (dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#9' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#10' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#3') + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' +and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') report.fobUsageMinimal.request.3.repeat=typeObjetId|column # deployes report.fobUsageMinimal.request.4=3,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#1' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' report.fobUsageMinimal.request.4.repeat=typeObjetId|column # Nombre de tortues report.fobUsageMinimal.request.5=4,0|row| \ Select Sum(efo.count) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Join dcp.objectObservedSpecies efo \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and efo.species.speciesGroup.id = 'fr.ird.observe.entities.referentiel.SpeciesGroup#1239832683690#0.24333033683679461' + and efo.species.speciesGroup.id = 'fr.ird.referential.common.SpeciesGroup#1239832683690#0.24333033683679461' report.fobUsageMinimal.request.5.repeat=typeObjetId|column ################################################################################ ## Utilisation des FOB, tableau detaille @@ -252,9 +252,9 @@ report.fobUsageExtended.repeatVariable.typeObjetId=java.lang.String|\ Where standardCode is not null \ And standardCode != '' \ And (Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ @@ -271,241 +271,241 @@ report.fobUsageExtended.request.1.repeat=typeObjetId|column # visite + peche report.fobUsageExtended.request.2=1,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.2.repeat=typeObjetId|column # visite - peche report.fobUsageExtended.request.3=2,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.3.repeat=typeObjetId|column # Deploiement + peche report.fobUsageExtended.request.4=3,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#1' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.4.repeat=typeObjetId|column # Deploiement - peche report.fobUsageExtended.request.5=4,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#1' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.5.repeat=typeObjetId|column # Modifie + peche report.fobUsageExtended.request.6=5,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.6.repeat=typeObjetId|column # Modifie - peche report.fobUsageExtended.request.7=6,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.7.repeat=typeObjetId|column # Retire + peche report.fobUsageExtended.request.8=7,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.8.repeat=typeObjetId|column # Retire - peche report.fobUsageExtended.request.9=8,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.9.repeat=typeObjetId|column # Abandonne + peche report.fobUsageExtended.request.10=9,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.10.repeat=typeObjetId|column # Abandonne - peche report.fobUsageExtended.request.11=10,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.11.repeat=typeObjetId|column # Coule + peche report.fobUsageExtended.request.12=11,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.12.repeat=typeObjetId|column # Coule - peche report.fobUsageExtended.request.13=12,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.13.repeat=typeObjetId|column # Remplace + peche report.fobUsageExtended.request.14=13,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#9' \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.14.repeat=typeObjetId|column # Remplace - peche report.fobUsageExtended.request.15=14,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#9' \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.15.repeat=typeObjetId|column # Autre ou ancien peche + peche report.fobUsageExtended.request.16=15,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and (dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#10' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#3') \ - and a.vesselActivitySeine.id = 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') \ + and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.16.repeat=typeObjetId|column # Autre ou ancien peche - peche report.fobUsageExtended.request.17=16,0|row|\ Select Count(dcp) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and (dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#10' \ - or dcp.objectOperation.id = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#3') \ - and a.vesselActivitySeine.id != 'fr.ird.observe.entities.referentiel.seine.VesselActivitySeine#1239832675369#0.12552908048322586' + and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \ + or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') \ + and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' report.fobUsageExtended.request.17.repeat=typeObjetId|column # Nombre de tortues report.fobUsageExtended.request.18=17,0|row| \ Select Sum(efo.count) \ - From TripSeineImpl m \ + From fr.ird.observe.entities.data.ps.common.TripImpl m \ Join m.route r \ - Join r.activitySeine a \ + Join r.activity a \ Join a.floatingObject dcp \ Join dcp.objectObservedSpecies efo \ Where \ m.id In :tripId \ and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \ - and efo.species.speciesGroup.id = 'fr.ird.observe.entities.referentiel.SpeciesGroup#1239832683690#0.24333033683679461' + and efo.species.speciesGroup.id = 'fr.ird.referential.common.SpeciesGroup#1239832683690#0.24333033683679461' report.fobUsageExtended.request.18.repeat=typeObjetId|column ################################################################################ ## Nombre des cal\u00e9es selon le type d'association View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/e2af824ecbf88127e5e9fe9b9f... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/e2af824ecbf88127e5e9fe9b9f... You're receiving this email because of your account on gitlab.com.