GeofenceConfigs
Retrieves a list of all geofence configs.
Table Specific Information
Select
Query the GeofenceConfigs table. The add-in 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 add-in.
- Id, TypeId and Type fields support the '=' and IN operators.
- Enabled field and ActiveStatus filter support the '=' operator.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM GeofenceConfigs WHERE TypeId IN (282316, 323445) AND Type = 'Locations' SELECT * FROM GeofenceConfigs WHERE Enabled = false
Columns
Name | Type | Description |
Id [KEY] | Int | Id of geofence config. |
Type | String | The type of entity the geofence config is related to. |
TypeId | Int | The id of the entity the geofence config is related to. |
Active | Boolean | Whether this geofence config is active. If false, this geofence config is archived. |
Enabled | Boolean | Indicates whether a geofence for the associated entity should be enabled. |
Radius | Int | Configures the size of the geofence. |
Created | Datetime | Date/time when this geofence config was created |
LastModified | Datetime | Date/time when this geofence config was last modified. |
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 |
ActiveStatus | String | Filter column for whether to fetch only active records, only archived records, or both. By default, only active records are fetched. Possible values are: yes, no, both |