Notifications_Notifications: Discourse Notification Entries
read only REST
- Catalog:
Discourse - Schema:
Notifications - Label: Notification Entries
Get notifications for the specified user
Can only retrieve data.
Summary
Get notifications for the specified user
API Source
- Endpoint:
/notifications.json - Operation:
get /notifications.json
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
username |
`` |
Table Columns
The columns of the table Notifications_Notifications are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
created_ |
varchar2 |
Created at | writable, created_ |
||
data_ |
int32 |
Data Badge ID | filters on the platform, writable, data. |
||
data_ |
varchar2 |
Data Badge Name | filters on the platform, writable, data. |
||
data_ |
varchar2 |
Data Badge Slug | filters on the platform, writable, data. |
||
data_ |
char |
Data Badge Title | filters on the platform, writable, data. |
||
data_ |
varchar2 |
Data Display Username | writable, data. |
||
data_ |
decimal |
Data Original Post ID | writable, data. |
||
data_ |
decimal |
Data Original Post Type | writable, data. |
||
data_ |
varchar2 |
Data Original User Name | writable, data. |
||
data_ |
varchar2 |
itgen_dce_data_revision_number | writable | The JSON text of the nested object. | |
data_ |
varchar2 |
Data Topic Title | writable, data. |
||
data_ |
varchar2 |
Data Username | filters on the platform, writable, data. |
||
fancy_ |
varchar2 |
Fancy Title | writable, fancy_ |
||
id |
decimal |
ID | writable, id |
||
load_ |
varchar2 |
Load More Notifications | filters on the platform, writable, ::ancestor. |
||
notification_ |
decimal |
Notification Type | writable, notification_ |
||
post_ |
decimal |
Post Number | writable, post_ |
||
read |
char |
Read | writable, read |
||
seen_ |
decimal |
Seen Notification ID | filters on the platform, writable, ::ancestor. |
||
slug |
varchar2 |
Slug | writable, slug |
||
topic_ |
decimal |
Topic ID | writable, topic_ |
||
total_ |
decimal |
Total Rows Notifications | filters on the platform, writable, ::ancestor. |
||
user_ |
int32 |
User ID | filters on the platform, writable, user_ |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
~data_badge_id(database_data_type:int32→int64)~data_badge_id(dotnet_data_type:int32→int64)-data_display_username-data_original_post_id-data_original_post_type-data_original_username-data_revision_number-data_topic_title-fancy_title~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)~notification_type(database_data_type:decimal→int64)~notification_type(dotnet_data_type:decimal→int64)~post_number(database_data_type:decimal→int64)~post_number(dotnet_data_type:decimal→int64)
10 more changes
Parameter username is removed from Discourse.Notifications.Notifications_Notifications
A call that passes the parameter fails after the upgrade.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 4
Discourse.Notifications.Notifications_Notifications: type changes
Type of Discourse.Notifications.Notifications_Notifications changes from tablefunction to table.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
tablefunction→table- importance 3
~seen_notification_id(database_data_type:decimal→int64)~seen_notification_id(dotnet_data_type:decimal→int64)~topic_id(database_data_type:decimal→int64)~topic_id(dotnet_data_type:decimal→int64)~total_rows_notifications(database_data_type:decimal→int64)~total_rows_notifications(dotnet_data_type:decimal→int64)~user_id(database_data_type:int32→int64)~user_id(dotnet_data_type:int32→int64)