diff options
Diffstat (limited to 'setup/windows')
| -rw-r--r-- | setup/windows/traccar.xml | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml index bf1b216af..80351325b 100644 --- a/setup/windows/traccar.xml +++ b/setup/windows/traccar.xml @@ -161,6 +161,10 @@ SELECT * FROM positions WHERE id IN (SELECT positionId FROM devices);
</entry>
+ <entry key='database.selectLatestPosition'>
+ SELECT TOP 1 * FROM positions WHERE deviceId = :deviceId AND protocol IS NOT NULL;
+ </entry>
+
<entry key='database.updateLatestPosition'>
UPDATE devices SET positionId = :id WHERE id = :deviceId;
</entry>
|