# HG changeset patch # User Andre Heinecke # Date 1369661816 -7200 # Node ID 5ba28b5636144a49e12dea4a531100e8aa8aac02 # Parent 2a4ff87ef357e473993041cc843727ef95b98659 Fix datacage for user data by adding facet filtering. Now the facets are joined in the user data select statement and afterwards we just filter on the facet name where previously new queryies were created. Grouping also fixes the repeating folders caused by the change in the statements during the large perfomance cleanup. diff -r 2a4ff87ef357 -r 5ba28b563614 artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Mon May 27 15:27:31 2013 +0200 +++ b/artifacts/doc/conf/meta-data.xml Mon May 27 15:36:56 2013 +0200 @@ -390,41 +390,21 @@ - - - - - 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 artifacts a - JOIN outs o ON o.artifact_id = a.id - JOIN facets f ON f.out_id = o.id - WHERE a.id = ${a_id} - AND f.name = ${facet_type} - + + - + + + + + - - - - - - - - - - - - +