# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1571237436 -7200
# Node ID a0c320d896823bf20fce5688fb8de0a42415f0ac
# Parent  8b6ffd9d0b18d861c9b711fe534e93d8315ba213
FA diagram: take latest available LDC.

As we have to take currently not active bottlenecks into account:
don't use the current LDC (which might not be available), but the
latest available one.

diff -r 8b6ffd9d0b18 -r a0c320d89682 pkg/controllers/bottlenecks.go
--- a/pkg/controllers/bottlenecks.go	Wed Oct 16 16:49:03 2019 +0200
+++ b/pkg/controllers/bottlenecks.go	Wed Oct 16 16:50:36 2019 +0200
@@ -84,8 +84,9 @@
 FROM waterway.gauges_reference_water_levels grwl
   JOIN waterway.bottlenecks bns
     ON grwl.location = bns.gauge_location
-      AND grwl.validity @> current_timestamp
-WHERE bns.validity @> current_timestamp
+      AND grwl.validity @> COALESCE(upper(bns.validity), current_timestamp)
+WHERE lower(bns.validity) = (SELECT max(lower(validity))
+                             FROM waterway.bottlenecks WHERE objnam = $1)
   AND bns.objnam = $1
   AND grwl.depth_reference like 'LDC%'
 `