spGetClientUser_NotificationSubscriptions

Parameters

Parameter Parameter Type Mode Description
@ClientUserID int IN

Definition

Copy




CREATE PROCEDURE [dbo].[spGetClientUser_NotificationSubscriptions]
    (
    @ClientUserID int
    )
    AS

    SELECT
    ID,
    UserID,
    NotificationID,
    ContextID,
    [Status],
    BackOfficeSystemPeopleID,
    BackOfficeSystemsID
    FROM NotificationSubscription
    WHERE UserID = @ClientUserID

    RETURN