diff options
| author | Simon Rettberg | 2018-12-07 16:27:27 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2018-12-07 16:27:27 +0100 |
| commit | 42c6170fd1f23c80462a64a704d395a85ce405c6 (patch) | |
| tree | 12ce5c0ccaf2406ecd7cf20488c33d443821efe8 | |
| parent | [server] Fix query (diff) | |
| download | tutor-module-42c6170fd1f23c80462a64a704d395a85ce405c6.tar.gz tutor-module-42c6170fd1f23c80462a64a704d395a85ce405c6.tar.xz tutor-module-42c6170fd1f23c80462a64a704d395a85ce405c6.zip | |
[server] Fix query
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java index 133ce846..ca4c3e3c 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java @@ -69,6 +69,7 @@ public class DbImage { + " LEFT JOIN imageversion lat ON (lat.imageversionid = i.latestversionid)" + " LEFT JOIN imageversion allv ON (allv.imagebaseid = i.imagebaseid)" + " LEFT JOIN imagepermission perm ON (i.imagebaseid = perm.imagebaseid AND perm.userid = :userid)" + + " GROUP BY imagebaseid" + Paginator.limitStatement(page)); stmt.setString("userid", user.userId); ResultSet rs = stmt.executeQuery(); |