diff options
| author | Michael Wilson | 2014-10-30 11:12:04 +0100 |
|---|---|---|
| committer | Michael Wilson | 2014-10-30 11:12:04 +0100 |
| commit | 494e999d3281a9e9c260087d6dfc8db36faa759f (patch) | |
| tree | a700aeceffb48d11d44bfa82ff832a55a9cfe36d /dozentenmodulserver/src/main/java/sql | |
| parent | fixed bug (diff) | |
| download | tutor-module-494e999d3281a9e9c260087d6dfc8db36faa759f.tar.gz tutor-module-494e999d3281a9e9c260087d6dfc8db36faa759f.tar.xz tutor-module-494e999d3281a9e9c260087d6dfc8db36faa759f.zip | |
Fixed bug when filtering for images
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index 25907f72..2effe4c7 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -467,7 +467,7 @@ public class SQL { // ResultSet
ResultSet res = stm
- .executeQuery("SELECT DISTINCT vl.GUID_imageID, vl.imageVersion, vl.image_name, vl.cond_hasLicenseRestriction, os.name, os.architecture, '' as lecture, vl.image_update_time, Concat(u.Nachname,' ',u.Vorname) as user, vl.image_isTemplate FROM bwLehrpool.pm_VLData_image pmi, bwLehrpool.m_VLData_imageInfo vl, bwLehrpool.m_operatingSystem os, bwLehrpool.m_user u WHERE pmi.userID='"
+ .executeQuery("SELECT DISTINCT vl.GUID_imageID, vl.imageVersion, vl.image_name, vl.image_description, vl.cond_hasLicenseRestriction, os.name, os.architecture, '' as lecture, vl.image_update_time, Concat(u.Nachname,' ',u.Vorname) as user, vl.image_isTemplate FROM bwLehrpool.pm_VLData_image pmi, bwLehrpool.m_VLData_imageInfo vl, bwLehrpool.m_operatingSystem os, bwLehrpool.m_user u WHERE pmi.userID='"
+ userID
+ "' AND u.userID = pmi.userID AND pmi.image_admin = 1 AND pmi.GUID_imageID = vl.GUID_imageID AND vl.content_operatingSystem=os.operatingSystemID;");
|