diff options
| -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(); |