SoftadminApi.Notification_EnqueueBatch

Show allHide all
Type: Stored procedure

Allows the creation of multiple notifications at once.

The procedure requires the temporary table:

CREATE TABLE #Notifications
(
	[UserId] int NOT NULL,
	[LoginLinkInstanceId] int NOT NULL,
	[Message] nvarchar(1000) NOT NULL,
	[SendPushNotifications] bit NOT NULL,
	[NotificationIdOut] uniqueidentifier NULL,
	[GroupId] uniqueidentifier NULL
);

NotificationIdOut will be set to the Id's of the new notifications by the procedure.

See SoftadminApi.Notification_Enqueue for further explaination of the other columns.

Parameters

@DismissExistingNotificationsInGroup optional bit
If 1, all existing notifications connected to the same UserId and GroupId will be deleted before the new notification is queued.