Retrieves a list of all geofence configs.
Table Specific Information
Query the GeoLocations table. The driver will use the TSheets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- Id, UserId and GroupId fields support the '=' and IN operators.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following query is processed server side:
SELECT * FROM GeoLocations WHERE GroupId IN ('29474', '29474') AND LastModified <= '2020-01-01 00:00'
|Id [KEY]||Int||Id of geolocation.|
|UserId||Int||User id for the user that this geolocation belongs to.|
|Accuracy||Double||Indicates the radius of accuracy around the geolocation in meters.|
|Altitude||Double||Indicates the altitude of the geolocation in meters.|
|Latitude||Double||Indicates the latitude of the geolocation in degrees.|
|Longitude||Double||Indicates the longitude of the geolocation in degrees.|
|Speed||Double||Indicates the speed of travel (meters per second) when the geolocation was recorded.|
|Source||String||Indicates how the GPS point was obtained. One of 'gps', 'wifi', or 'cell'.|
|DeviceIdentifier||String||Unique identifier (for the given client) for the device associated with this geolocation.|
|Created||Datetime||Date/time when this geolocation was created|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|LastModified||Datetime||Date/time when this geofence config was last modified.|
|GroupId||String||A comma-separated list of group ids. Only geolocations linked to users from these groups will be returned.|