server/util/Migrator/DbScripts/2026-04-13_02_SendReadFilesByUserIdAndOrganizationId.sql

CREATE OR ALTER PROCEDURE [dbo].[Send_ReadFilesByUserId]
    @UserId UNIQUEIDENTIFIER
AS
BEGIN
    SET NOCOUNT ON

    SELECT
        *
    FROM
        [dbo].[SendView]
    WHERE
        [OrganizationId] IS NULL
        AND [UserId] = @UserId
        AND [Type] = 1
END
GO

CREATE OR ALTER PROCEDURE [dbo].[Send_ReadFilesByOrganizationId]
    @OrganizationId UNIQUEIDENTIFIER
AS
BEGIN
    SET NOCOUNT ON

    SELECT
        *
    FROM
        [dbo].[SendView]
    WHERE
        [OrganizationId] = @OrganizationId
        AND [Type] = 1
END
GO