GeoLocations
Retrieves a list of all geofence configs.
Table Specific Information
Select
Query the GeoLocations table. The 本製品 will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- 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'
Insert
Insert can be executed by specifying the Created, UserId, Accuracy, Altitude, Latitude and Longitude columns. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Geolocations (Created, UserId, Accuracy, Altitude, Latitude, Longitude) VALUES ('2018-08-19T11:30:09-06:00', '1242515', '20.375', '0', '43.68662580', '-116.35166460')
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Int | True |
Id of geolocation. |
UserId | Int | False |
User id for the user that this geolocation belongs to. |
Accuracy | Double | False |
Indicates the radius of accuracy around the geolocation in meters. |
Altitude | Double | False |
Indicates the altitude of the geolocation in meters. |
Latitude | Double | False |
Indicates the latitude of the geolocation in degrees. |
Longitude | Double | False |
Indicates the longitude of the geolocation in degrees. |
Speed | Double | False |
Indicates the speed of travel (meters per second) when the geolocation was recorded. |
Source | String | False |
Indicates how the GPS point was obtained. One of 'gps', 'wifi', or 'cell'. |
DeviceIdentifier | String | False |
Unique identifier (for the given client) for the device associated with this geolocation. |
Created | Datetime | True |
Date/time when this geolocation was created |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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. |