Notifications
Update, delete, and query notifications for a customer.
Table Specific Information
Select
To get a list of all the notifications, the CustomerId column is required. It can be set in the connection string or in the WHERE clause condition. If not specified, the CustomerId of the current account will be used.
For example, the following query is processed server side by the Google Directory APIs:
SELECT * FROM Notifications
INSERT
INSERTs are not supported for this table.
Update
To update a notification, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.
UPDATE Notifications SET IsUnread = true WHERE Id = '12345' AND CustomerId = '1234'.
Delete
To delete a notification, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.
DELETE FROM Notifications WHERE CustomerId = '1234' AND Id = '12345'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
Id of the notification |
Subject | String | False |
Subject of the notification |
Body | String | True |
The body of the notification |
SendDate | Datetime | True |
The date when the notification was sent |
FromAddress | String | True |
The address from which the notification is recieved |
IsUnread | Boolean | False |
Indicates wether the notification is unread or not |
ETag | String | True |
ETag of the resource |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CustomerId | String |
Id of the customer |