# HG changeset patch # User Felix Wolfsteller # Date 1345016471 0 # Node ID ab447cd29b735b246bfb906cd32bc15402e3c4b7 # Parent 76571c601d06a15f18c6ad2d70036a506e2947d0 More former calculations in FixA DC. flys-artifacts/trunk@5205 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 76571c601d06 -r ab447cd29b73 flys-artifacts/ChangeLog --- a/flys-artifacts/ChangeLog Tue Aug 14 14:02:28 2012 +0000 +++ b/flys-artifacts/ChangeLog Wed Aug 15 07:41:11 2012 +0000 @@ -1,3 +1,7 @@ +2012-08-14 Felix Wolfsteller + + * doc/conf/meta-data.xml: More former calculations in fixA DC. + 2012-08-13 Felix Wolfsteller * doc/conf/artifacts/fixanalysis.xml: Add discharge curve facet to diff -r 76571c601d06 -r ab447cd29b73 flys-artifacts/doc/conf/meta-data.xml --- a/flys-artifacts/doc/conf/meta-data.xml Tue Aug 14 14:02:28 2012 +0000 +++ b/flys-artifacts/doc/conf/meta-data.xml Wed Aug 15 07:41:11 2012 +0000 @@ -1522,7 +1522,7 @@ SELECT name AS facet_name, num as facet_num, description AS facet_description FROM facets - WHERE out_id = ${out_id} AND ( name LIKE 'fix_deviation_ls%' OR name LIKE 'fix_sector_average_ls%' ) + WHERE out_id = ${out_id} AND ( name LIKE 'fix_deviation_ls%' OR name LIKE 'fix_sector_average_ls%' OR name LIKE 'fix_analysis_events_ls%' OR name LIKE 'fix_reference_events_ls%' ) ORDER BY num ASC, name DESC @@ -1594,6 +1594,54 @@ + + + + + + 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 id AS out_id + FROM outs + WHERE artifact_id = ${a_id} AND name = 'fix_derivate_curve' + + + + + SELECT name AS facet_name, num as facet_num, description AS facet_description + FROM facets + WHERE out_id = ${out_id} and name = 'fix_derivate' + ORDER BY num ASC, name DESC + + + + + + + + + + + + + + + + + + + + + + @@ -1679,7 +1727,8 @@ WATERLEVELS - ONLY SHOW Ws - + +