Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 550:68f01f10624e
Introduced helper for finding the user name for a given artifact
| author | gernotbelger |
|---|---|
| date | Fri, 09 Feb 2018 13:26:19 +0100 |
| parents | e9abf747f6ce |
| children |
comparison
equal
deleted
inserted
replaced
| 549:e781b847fdca | 550:68f01f10624e |
|---|---|
| 183 FROM \ | 183 FROM \ |
| 184 users u INNER JOIN collections c ON u.id = c.owner_id \ | 184 users u INNER JOIN collections c ON u.id = c.owner_id \ |
| 185 INNER JOIN collection_items ci ON c.id = ci.collection_id \ | 185 INNER JOIN collection_items ci ON c.id = ci.collection_id \ |
| 186 INNER JOIN artifacts a ON a.id = ci.artifact_id \ | 186 INNER JOIN artifacts a ON a.id = ci.artifact_id \ |
| 187 ORDER BY u_gid, c_gid | 187 ORDER BY u_gid, c_gid |
| 188 | |
| 189 find.user.by.artifact = \ | |
| 190 SELECT users.id, users.name FROM users, collections, collection_items, artifacts \ | |
| 191 WHERE users.id = collections.owner_id AND \ | |
| 192 collections.id = collection_items.collection_id AND \ | |
| 193 collection_items.artifact_id = artifacts.id AND \ | |
| 194 artifacts.gid = ?::uuid |