JDBC Driver for QuickBooks Time

Build 24.0.9062

Notifications

Retrieves a list of notifications associated with your company.

Table Specific Information

Select

Query the Notifications table. The 本製品 will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062