JDBC Driver for TSheets

Build 20.0.7654

GeoLocations

Retrieves a list of all geofence configs.

Table Specific Information

Select

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'

Columns

Name Type Description
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-Columns

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.

Name Type Description
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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654