Hello All,
As you know there is no tables saving trips in database. So I need a query that getting trip based on two dates.
(Im using Postgres as SGBD and Traccar 6.11.1)
My config is below :
<entry key='database.driver'>org.postgresql.Driver</entry>
<entry key='database.url'>{{ default (printf "jdbc:postgresql://postgres.%s.svc.cluster.local:5432/traccar_db" .Release.Namespace) $db.url }}</entry>
<entry key='database.user'>{{ default .Values.global.postgres.user $db.user }}</entry>
<entry key='database.password'>{{ default .Values.global.postgres.password $db.password }}</entry>
<entry key='web.address'>0.0.0.0</entry>
<entry key='web.port'>{{ .Values.services.traccar.webPort }}</entry>
<entry key='logger.console'>true</entry>
<entry key='logger.file'>true</entry>
<entry key='logger.file.path'>/opt/traccar/logs/traccar.log</entry>
Thanks in advance.
You can get stopped/moving events and that would be your trips.
Hello All,
As you know there is no tables saving trips in database. So I need a query that getting trip based on two dates.
(Im using Postgres as SGBD and Traccar 6.11.1)
My config is below :
<entry key='database.driver'>org.postgresql.Driver</entry> <entry key='database.url'>{{ default (printf "jdbc:postgresql://postgres.%s.svc.cluster.local:5432/traccar_db" .Release.Namespace) $db.url }}</entry> <entry key='database.user'>{{ default .Values.global.postgres.user $db.user }}</entry> <entry key='database.password'>{{ default .Values.global.postgres.password $db.password }}</entry> <entry key='web.address'>0.0.0.0</entry> <entry key='web.port'>{{ .Values.services.traccar.webPort }}</entry> <entry key='logger.console'>true</entry> <entry key='logger.file'>true</entry> <entry key='logger.file.path'>/opt/traccar/logs/traccar.log</entry>Thanks in advance.