This table contains a list of all groups associated with your company.
Table Specific Information
Query the Groups table. The component 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 component.
- 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
|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.|