view etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 6693:88bb0c794833

issue1391: Enable GaugeDischarge artifact to directly load a table by its ID This allows us to use the GaugeDischargeArtifact for any discharge tables that we have in our database. The name of the created facet is taken from the ids string as is also usual in the WMS artifacts.
author Andre Heinecke <aheinecke@intevation.de>
date Mon, 29 Jul 2013 12:19:57 +0200
parents 5aa05a7a34b7
children
line wrap: on
line source
select.abflusstafel = \
    SELECT ABFLUSSTAFEL_NR, \
           ABFLUSSTAFEL_BEZ, \
           GUELTIG_VON, \
           GUELTIG_BIS, \
           PEGELNULLPUNKT, \
           AT.BFG_ID \
    FROM ABFLUSSTAFEL AT \
    WHERE MESSSTELLE_NR LIKE :number

http://dive4elements.wald.intevation.org