# HG changeset patch # User Sascha L. Teichmann # Date 1312885545 0 # Node ID 3d36e6000915c28345cc7b3cab9674c9744e42b3 # Parent a776afdf1ec592a5c02f4ce7777d272456310101 Added element around old calculations. flys-artifacts/trunk@2476 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r a776afdf1ec5 -r 3d36e6000915 flys-artifacts/ChangeLog --- a/flys-artifacts/ChangeLog Tue Aug 09 10:23:04 2011 +0000 +++ b/flys-artifacts/ChangeLog Tue Aug 09 10:25:45 2011 +0000 @@ -1,3 +1,8 @@ +2011-08-09 Sascha L. Teichmann + + * doc/conf/meta-data-user.xml: Added element + around old calculations. + 2011-08-09 Sascha L. Teichmann * src/main/java/de/intevation/flys/artifacts/model/QRangeTree.java: diff -r a776afdf1ec5 -r 3d36e6000915 flys-artifacts/doc/conf/meta-data-user.xml --- a/flys-artifacts/doc/conf/meta-data-user.xml Tue Aug 09 10:23:04 2011 +0000 +++ b/flys-artifacts/doc/conf/meta-data-user.xml Tue Aug 09 10:25:45 2011 +0000 @@ -6,48 +6,50 @@ ------------------ - - SELECT id as user_id FROM users WHERE gid = CAST(${user-id} AS uuid) - - - SELECT id AS collection_id FROM collections WHERE user_id = ${user_id} - - - SELECT a.id AS a_id, a.state AS a_state, a.gid as a_gid FROM - collection_items ci JOIN artifacts a ON ci.artifact_id = a.id - WHERE collection_id = ${collection_id} AND a.state = ${current-state-id} AND a.gid <> CAST(${artifact-id} AS uuid) - AND EXISTS (SELECT id FROM artifact_data WHERE artifact_id = a.id AND k = 'river' AND v = ${river}) - - --- TODO: We only need the 'master' artifacts! --- - - - - - SELECT id AS out_id FROM outs WHERE artifact_id = ${a_id} AND name = 'longitudinal_section' - - - SELECT name AS facet_name, num as facet_num, description AS facet_description - FROM facets WHERE out_id = ${out_id} ORDER BY num ASC, name DESC - - - - - - - - - - - - - - - - - - - - + + + SELECT id as user_id FROM users WHERE gid = CAST(${user-id} AS uuid) + + + SELECT id AS collection_id FROM collections WHERE user_id = ${user_id} + + + SELECT a.id AS a_id, a.state AS a_state, a.gid as a_gid FROM + collection_items ci JOIN artifacts a ON ci.artifact_id = a.id + WHERE collection_id = ${collection_id} AND a.state = ${current-state-id} AND a.gid <> CAST(${artifact-id} AS uuid) + AND EXISTS (SELECT id FROM artifact_data WHERE artifact_id = a.id AND k = 'river' AND v = ${river}) + + --- TODO: We only need the 'master' artifacts! --- + + + + + SELECT id AS out_id FROM outs WHERE artifact_id = ${a_id} AND name = 'longitudinal_section' + + + SELECT name AS facet_name, num as facet_num, description AS facet_description + FROM facets WHERE out_id = ${out_id} ORDER BY num ASC, name DESC + + + + + + + + + + + + + + + + + + + + +