sp_sql_remove_notifications

sp_sql_remove_notifications

This notification procedure removes notifications from the Virtual Ticket/Job Manager/Digital Storage Manager system.

sp_sql_remove_notifications

 

Parameters

Value

Description

Notes

@user_id

integer

The ID of the user removing the notification (usually a notification target).

 

@notification_ids_query

t_nstring

The ID’s of the notifications to be removed. A syntactically correct SQL query whose result is one column of notification ID’s.

 

@remove_pending

integer = 0

An optional parameter that indicates whether notifications must be acknowledged before they can be removed.

0 - Removes notifications only if they have been acknowledged.

1 - Removes both pending and acknowledged notifications.

 

For example code that uses this procedure, please see “Removing Notifications” on page 17.


Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.