Notifications
Retrieves a list of notifications associated with your company.
Table Specific Information
Select
Query the Notifications 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 field supports the '=' and IN operators.
- MessageTrackingId and UserId fields support the '=' operator.
- DeliveryTime field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM Notifications WHERE Id IN (94140223, 94140225) AND UserId = 37 SELECT * FROM Notifications WHERE MessageTrackingId = 'baabeb0ab03d62ce' SELECT * FROM Notifications WHERE DeliveryTime = '2019-12-25 19:00'
Insert
Insert can be executed by specifying the Message column. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table
INSERT INTO Notifications (Message) VALUES ('Please clock Out!') INSERT INTO Notifications (Message, UserId) VALUES ('Please clock Out!', '56329')
Delete
Delete can be executed by specifying the Id in the WHERE Clause.
For example:
DELETE FROM Notifications WHERE Id = '41321421' DELETE FROM Notifications WHERE Id IN ('41321421', '4132567')
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Integer | True |
Id of the notification. |
UserId | Integer | True |
User id for the user that this notification will be sent to. |
MessageTrackingId | String | True |
A GUID string used for additional tracking. |
Message | String | False |
The message text of the notification. The maximum message length is 2000 characters. |
Method | String | False |
The transport method of the notification. We support 'push', 'email', and 'dashboard'. |
Precheck | String | False |
The precheck macro name. Supported macros are 'on_the_clock', 'off_the_clock', and 'none'. |
Created | Datetime | True |
Date/time when this notification was created |
DeliveryTime | Datetime | False |
Date/time when this notification will be delivered. |