# HG changeset patch # User Felix Wolfsteller # Date 1369300918 -7200 # Node ID cd8f77794a03d3eaa95b8493a4c80a06ab0350b7 # Parent dcbc06ca5d19dfadcc68c004a92bd76282477a25 meta-data.xml: Fix query, select on user-id not collection-id. diff -r dcbc06ca5d19 -r cd8f77794a03 artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Thu May 23 11:18:51 2013 +0200 +++ b/artifacts/doc/conf/meta-data.xml Thu May 23 11:21:58 2013 +0200 @@ -2637,7 +2637,7 @@ FROM users u JOIN collections c ON c.user_id = u.id JOIN master_artifacts_range ma ON ma.collection_id = c.id - WHERE c.id = ${collection_id} + WHERE u.gid = CAST(${user-id} AS UUID) AND ma.gid <> CAST(${artifact-id} AS uuid) AND EXISTS ( SELECT id