Notes

USE [NIKU]
GO
/****** Object: Trigger [niku].[CLB_DMS_FOLDERS_T2] Script Date: 21/02/2022 11:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [niku].[CLB_DMS_FOLDERS_T2]

ON [niku].[CLB_DMS_FOLDERS]
FOR UPDATE
AS
BEGIN
SET NOCOUNT ON
DECLARE
@v_parent_folder_id NUMERIC,
@v_id NUMERIC,
@v_old_parent_folder_id NUMERIC,
@v_old_id NUMERIC

SELECT @v_id = ID, @v_parent_folder_id = parent_folder_id
FROM inserted

SELECT @v_old_id = ID, @v_old_parent_folder_id = parent_folder_id
FROM deleted

EXEC CLB_UPDT_FLAT_FOLDER_HIERS_SP @v_old_id, @v_old_parent_folder_id,@v_id, @v_parent_folder_id

UPDATE CLB_DMS_FOLDERS
SET
CREATED_DATE = inserted.created_date ,
CREATED_BY = inserted.created_by ,
LAST_UPDATED_DATE = inserted.last_updated_date ,
LAST_UPDATED_BY= inserted.last_updated_by ,
OWNER_ID = inserted.owner_id,
NAME = inserted.name,
PATH_NAME = inserted.path_name ,
FOLDER_TYPE = inserted.folder_type ,
IS_SEARCHABLE = inserted.is_searchable ,
IS_SYSTEM_CREATED = inserted.is_system_created ,
IS_VISIBLE = inserted.is_visible,
HAS_ALL_PARTICIPANTS = inserted.has_all_participants,
PARENT_FOLDER_ID = inserted.parent_folder_id,
AREA_ID= inserted.area_id ,
OWNER_GROUP_ID= inserted.owner_group_id ,
ASSOC_OBJ_ID = inserted.assoc_obj_id ,
ASSOC_OBJ_TYPE = inserted.assoc_obj_type
FROM inserted, clb_dms_folders cd
WHERE cd.id = @v_id
SET NOCOUNT OFF
END