Why are new documents created in the "unknown" area?

If the area "default" was chosen when uploading?

How can I change this behavior?

Parents
  • 0
    I wrote this database trigger for the document problem:

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    -- =====================================================
    -- Author: Sven Gak
    -- Create date: 01.12.2020
    -- Description: Setzte die benötigten Dokumentenrechte
    -- =====================================================
    CREATE TRIGGER OverwriteDocumentArea
    ON [dbo].[Library]
    AFTER INSERT
    AS
    BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    declare @SecTerr int, @UserId int, @UserSecTerr int, @LibraryId int;
    SELECT @SecTerr = inserted.Libr_SecTerr, @UserId = inserted.Libr_CreatedBy, @LibraryId = inserted.Libr_LibraryId FROM inserted;

    IF (ISNULL(@SecTerr, 0) = 0 OR ISNULL(@SecTerr, 0) = -2147483644)
    BEGIN
    SELECT @UserSecTerr = User_PrimaryTerritory FROM Users WHERE User_UserId = @UserId;
    UPDATE [dbo].[Library] SET Libr_SecTerr = @UserSecTerr WHERE Libr_LibraryId = @LibraryId
    END
    END
    GO

  • 0 in reply to Sven Gak

    Please do log a case.

Reply Children
No Data