# HG changeset patch # User Felix Wolfsteller # Date 1336943625 0 # Node ID 15c6f79ca3e212a2828e99fda965d083856762b1 # Parent 3ab7b593c6e58bc49b0f08140511536cf68b5575 Add duration_curve.q loading via datacage. flys-artifacts/trunk@4394 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 3ab7b593c6e5 -r 15c6f79ca3e2 flys-artifacts/doc/conf/meta-data.xml --- a/flys-artifacts/doc/conf/meta-data.xml Fri May 11 12:14:36 2012 +0000 +++ b/flys-artifacts/doc/conf/meta-data.xml Sun May 13 21:13:45 2012 +0000 @@ -1029,7 +1029,7 @@ - + @@ -1076,6 +1076,39 @@ + + + + + + SELECT m.id AS a_id, m.state AS a_state, m.gid AS a_gid, m.creation AS a_creation + FROM master_artifacts m + WHERE m.collection_id = ${collection_id} AND m.gid <> CAST(${artifact-id} AS uuid) + AND EXISTS ( + SELECT id FROM artifact_data ad WHERE ad.artifact_id = m.id AND k = 'river' AND v = ${river}) + + + + + SELECT a.gid as aid, f.id AS fid, f.name AS facet_name, f.num AS facet_num, f.description as facet_description + FROM outs as o, facets as f, artifacts as a + WHERE f.name = 'duration_curve.q' and f.out_id = o.id and o.artifact_id = ${a_id} and a.id = ${a_id} + + + + + + + + + + + + + + + + WATERLEVELS - ONLY SHOW Ws