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