Query for getting trips between two dates

zelhanid 4 days ago

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.

Anton Tananaev 4 days ago

You can get stopped/moving events and that would be your trips.