FireDAC Components for TSheets

Build 20.0.7654

Groups

This table contains a list of all groups associated with your company.

Table Specific Information

Select

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

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.

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