Removing Notifications

To remove notifications using SQL SDK, the sp_sql_remove_nofications procedure must be used.

exec sp_sql_remove_notifications

@user_id = 6,

@notification_ids_query =

'SELECT row_id FROM ea_notifications',

@remove_pending = 1

The @notification_ids_query parameter must be a syntactically correct SQL query whose result is one column of notification ID’s.

If the @remove_pending parameter is set to 0 (the default condition), the procedure removes the notifications whose ID’s have been retrieved by @notification_ids_query only if they have all been acknowledged; if some of the notifications are still pending, an error is generated and no notifications are removed. To remove notifications without requiring that they have been acknowledged, use @remove_pending = 1.