# HG changeset patch # User Andre Heinecke # Date 1369154192 -7200 # Node ID 5db238b0176e6c19c07d05dafe44a08a32012742 # Parent a18aafc1372f58b67a681ec331414f9b3afd9b76 Readd accidentally removed macros diff -r a18aafc1372f -r 5db238b0176e artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Tue May 21 18:00:29 2013 +0200 +++ b/artifacts/doc/conf/meta-data.xml Tue May 21 18:36:32 2013 +0200 @@ -1783,6 +1783,42 @@ + + + + SELECT DISTINCT + name AS hws_name, + official AS hws_official, + kind_id AS hws_kind + FROM hws_lines + WHERE river_id = ${river_id} + + + + + + + + + + + + + SELECT DISTINCT + name AS hws_name, + official AS hws_official, + kind_id AS hws_kind + FROM hws_points + WHERE river_id = ${river_id} + + + + + + + + + @@ -2508,6 +2544,60 @@ + + + + + + + SELECT m.id AS a_id, + m.state AS a_state, + m.gid AS a_gid, + m.creation AS a_creation, + ardg.v AS gaugy, + arv.v AS wqsingle + FROM master_artifacts m, + artifact_data ardg, + artifact_data arv + WHERE m.collection_id = ${collection_id} + AND m.gid = CAST(${artifact-id} AS uuid) + AND ardg.artifact_id = m.id + AND ardg.k = 'ld_gaugename' + AND arv.artifact_id = m.id + AND arv.k = 'wq_single' + AND EXISTS ( + SELECT id + FROM artifact_data ad + WHERE ad.artifact_id = m.id + AND k = 'river' + AND v = ${river}) + + + + + SELECT ol.wst_id AS wstid, + ol.wst_column_pos AS wstcolpos, + ol.name AS olname, + ol.value AS oval + FROM official_q_values ol + WHERE ol.value = CAST(${wqsingle} AS NUMERIC(10,2)) + AND ol.gauge_name = ${gaugy} + + + + + + + + + + + + + + + +