Trip Reports not showing for any time period beyond Yesterday

[raetha]

Describe the bug When using Trip reports I can readily see trips for Today and Yesterday, but selecting any other time period results in no returned trips. I would at least expect the Trips that show for Today and Yesterday to also show when selecting This Week or This Month. Trips appear to be properly detected, just not being returned and displayed with periods that cross multiple days. Custom searches that line up exactly with a single day also work, though fail as soon as they cross into a second day. No errors are generated in the logs that I can find, just no results display in UI.

It may be worth mentioning that Routes and Events work as expected.

To Reproduce Steps to reproduce the behavior:

1. Go to 'Reports'
2. Go to 'Trips'
3. Select 'Device'
4. Change 'Period' to 'Today'
5. See valid Trips
6. Change 'Period' to 'This Week'
7. See no Trips

Expected behavior Any trips for the selected Period should display.

Desktop (please complete the following information):

• OS: Windows 11
• Browser: Edge

Server

• OS: Docker
• DB: PostgreSQL 15.5
• Devices: Freematics
• Configuration: mostly default aside from geocoder and database

[tananaev]

The issue is probably with the fast reports. They use events for calculating trips. Check events report for the same period.

There are a bunch of threads about it on the forum. I would recommend reading those first.