Groups
This table contains a list of all groups associated with your company.
Table Specific Information
Select
Query the Groups table. The adapter 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 adapter.
- Id and Name fields support the '=' and IN operators.
- Active field supports the '=' operator.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM Groups WHERE Name IN ('Group 1', 'Group 2') and LastModified > '2019-01-01 15:30'
SELECT * FROM Groups WHERE Active = true
Columns
| Name | Type | Description |
| Id [KEY] | String | ID of this group. |
| Active | Boolean | If false, this group is considered archived. |
| Name | String | Name associated with this group |
| LastModified | Datetime | Date/time when this group was last modified |
| Created | Datetime | Date/time when this group was created |
| ManagerIds | Int | List of id's for the users allowed to manage this group. |