Bug #3911
Implementasi Function Trigger untuk Hapus ID di PA68 (Foto) ketika PA19 dihapus
Description
Dear Team Developer,
Mohon bantuannya untuk menambahkan validasi saat melakukan penghapusan data di PHRPA0019.
- Jika ada data yang dihapus di Attendance (PHRPA0019), maka data terkait di PHRPA0068 dengan field ID yang sama juga ikut terhapus (foto ikut terhapus), nama field di PHRPA0019 = AuditorFlag, nama field di PHRPA0068 = ID.
- Penghapusan ini harus sesuai dengan StartDate, EndDate, dan EmployeeID ya.
Boleh implementasikan dulu di port Easy untuk keperluan testing.
Terima kasih
https://easy.minovais.com/
aktivasi code : EASY
db: 103.153.60.89
MinovaES_Easy
Files
Updated by Kezia Pawitra Yulianti 2 days ago
- Due date set to 09/23/2025
- Status changed from New to Assigned
- Assignee changed from Kezia Pawitra Yulianti to M Azid Wahyudi
- Priority changed from Normal to Urgent
Updated by M Azid Wahyudi 1 day ago
- Status changed from Assigned to QA Test
- Assignee changed from M Azid Wahyudi to Mr Ikmal
dear ikmal , udah bisa di test
package :
ada di pertalife MinovaES_Pertalife_Prod_62225 di table phrpa0019 trigger namanya trg_Delete_PHRPA0019
trigger di bawah ini
ALTER TRIGGER [dbo].[trg_Delete_PHRPA0019]
ON [dbo].[PHRPA0019]
AFTER DELETE
AS
BEGIN
-- Delete matching rows from PHRPA0068 based on AuditorFlag, EmployeeID, and StartDate
DELETE P68
FROM PHRPA0068 P68
INNER JOIN deleted d
ON d.AuditorFlag = P68.id
AND d.EmployeeID = P68.EmployeeID
AND d.StartDate = P68.StartDate
WHERE d.AuditorFlag IS NOT NULL
AND d.EmployeeID IS NOT NULL
AND d.StartDate IS NOT NULL;
END;
makasih
Updated by Muhammad Bintar about 23 hours ago
- File clipboard-202509231746-8gu8v.png clipboard-202509231746-8gu8v.png added
- Status changed from Deploy to Closed
- Assignee changed from Muhammad Bintar to M Azid Wahyudi
okeh udah di deploy ya