spGetMessages_Inbox
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OwnerAccountID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetMessages_Inbox]
(
@OwnerAccountID int
)
AS
BEGIN
SELECT
2 'MessageType',
i.ID 'MessageID',
i.Viewed
FROM [Message] i
WHERE i.OwnerID = @OwnerAccountID
AND i.OwnerID = i.RecipientID
AND i.Deleted = 0
AND i.Sent = 0
AND (i.MessageFolderID = 0 OR i.MessageFolderID IS NULL)
ORDER BY i.CreateDate DESC
END