invantive documentation
Invantive Support ForumsLog In / Sign Up

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_at varchar2 Created at writable, created_at
data_badge_id int32 Data Badge ID filters on the platform, writable, data.badge_id
data_badge_name varchar2 Data Badge Name filters on the platform, writable, data.badge_name
data_badge_slug varchar2 Data Badge Slug filters on the platform, writable, data.badge_slug
data_badge_title char Data Badge Title filters on the platform, writable, data.badge_title
data_display_username varchar2 Data Display Username writable, data.display_username
data_original_post_id decimal Data Original Post ID writable, data.original_post_id
data_original_post_type decimal Data Original Post Type writable, data.original_post_type
data_original_username varchar2 Data Original User Name writable, data.original_username
data_revision_number varchar2 itgen_dce_data_revision_number writable The JSON text of the nested object.
data_topic_title varchar2 Data Topic Title writable, data.topic_title
data_username varchar2 Data Username filters on the platform, writable, data.username
fancy_title varchar2 Fancy Title writable, fancy_title
id decimal ID writable, id
load_more_notifications varchar2 Load More Notifications filters on the platform, writable, ::ancestor.load_more_notifications
notification_type decimal Notification Type writable, notification_type
post_number decimal Post Number writable, post_number
read char Read writable, read
seen_notification_id decimal Seen Notification ID filters on the platform, writable, ::ancestor.seen_notification_id
slug varchar2 Slug writable, slug
topic_id decimal Topic ID writable, topic_id
total_rows_notifications decimal Total Rows Notifications filters on the platform, writable, ::ancestor.total_rows_notifications
user_id int32 User ID filters on the platform, writable, user_id

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)

All changes of the driver, 26.0 to 27.0