# Notifications: Nextcloud Nextcloud Notifications ## Documentation Notifications of the connected account, one row per notification. Delete only: a notification is generated by Nextcloud itself. - Catalog: `Nextcloud` - Schema: `Nextcloud` - Primary Keys: `notification_id` - Label: Nextcloud Notifications - Retrieve: True - Insert: False - Update: False - Delete: True ## Columns of Table Function The columns of the table function `Notifications` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `app` | `varchar2` | | ☐ | Application the notification originated from. | | `icon` | `varchar2` | | ☐ | URL of the icon shown beside the notification. | | `link` | `varchar2` | | ☐ | Link the notification points to, where it has one. | | `message_rich_parameters` | `varchar2` | | ☐ | Parameters of message_rich, as JSON. The structure differs per notification type. | | `message_rich` | `varchar2` | | ☐ | Message with rich-text placeholders, as the platform renders it. | | `message` | `varchar2` | | ☐ | Plain-text message body. | | `notification_date` | `datetime` | | ☐ | Moment the notification was generated. | | `notification_id` | `int64` | | ☑ | Identifier of the notification. The where clause of a delete, never a value it writes. | | `object_id` | `varchar2` | | ☐ | Identifier of the object the notification is about. | | `object_type` | `varchar2` | | ☐ | Type of the object the notification is about. | | `should_notify` | `char` | | ☐ | Whether the platform still owes the user an active notification (push, email) for this row. | | `subject_rich_parameters` | `varchar2` | | ☐ | Parameters of subject_rich, as JSON. The structure differs per notification type. | | `subject_rich` | `varchar2` | | ☐ | Subject with rich-text placeholders, as the platform renders it. | | `subject` | `varchar2` | | ☐ | Short, plain-text subject. | | `user` | `varchar2` | | ☐ | Login name of the account the notification was sent to. |