1 files changed, 8 insertions, 2 deletions
diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java
index 9633ada58..35e9cff95 100644
--- a/src/org/traccar/database/DataManager.java
+++ b/src/org/traccar/database/DataManager.java
@@ -46,6 +46,7 @@ import org.traccar.model.Permission;
 import org.traccar.model.Position;
 import org.traccar.model.Server;
 import org.traccar.model.User;
+import org.traccar.model.Alert;
 
 import com.mchange.v2.c3p0.ComboPooledDataSource;
 
@@ -322,5 +323,10 @@ public class DataManager {
                 .setObject(server)
                 .executeUpdate();
     }
-
-}
+    
+    public Collection<Alert> getAlertsByDevice(Long deviceId) throws SQLException {
+        return QueryBuilder.create(dataSource, properties.getProperty("database.getAlertsByDevice"))
+                .setLong("deviceId", deviceId)
+                .executeQuery(new Alert());
+    }
+}
+\ No newline at end of file