Solved

Extending the gpsdata retention time

  • 12 September 2023
  • 5 replies
  • 62 views

Userlevel 3
Badge +6

There is a table in the database called gpsdata that logs technicians’ gps coordinates, currently it retains about 3 days worth of gps data per user. We’re wondering if that timeframe is configurable. (We want to extend it to 7 days).

Does anyone know if that is configurable within the application?

icon

Best answer by Reid Gilbert 12 September 2023, 18:28

View original

5 replies

Userlevel 7
Badge +15

Take a look in the Coniguration Editor (under the Profile got to Timers) and click on the ClearGPSData entry in there:
 

Thanks,
Reid

Userlevel 3
Badge +6

Thanks Reid, that’s exactly what I was looking for. However it’s a bit weird, currently we have that set to 1 DaysToKeep, despite our database having data from 5 days ago (although the majority of the data is from the last day). Any idea why it would be retaining records beyond that parameter?

GPS Records by Day

 

Userlevel 7
Badge +15

I suspect maybe it’s really an issue where the timer isn’t firing, so try changing the repeatInterval to 3600 and the DaysToKeep to 2 and then hit SAVE and then do an IISRESET (maybe those values were cached so that should flush/update them).  Then wait an hour and see if it purges everything after 2 days...if that still doesn’t do the trick then log a ticket for it in the support system so we can dig into it further.
Thanks,
Reid

Userlevel 3
Badge +6

Note for future viewers on this thread. We were recently informed that the parameter above has been deprecated, and this configuration is now controlled on the Workflow(Mobile) settings. 

 

Userlevel 7
Badge +21

Thank you, Kevin.

Good to know!

 

Reply