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