Bug #3911
Implementasi Function Trigger untuk Hapus ID di PA68 (Foto) ketika PA19 dihapus
Added by Mr Ikmal 2 days ago.
Updated about 24 hours ago.
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
- 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
- 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
deploy ke easy , ekno , pertalife
- Status changed from QA Test to Deploy
- Assignee changed from Mr Ikmal to Muhammad Bintar
Mas bin tolong bantu deploy ya mas.
Terima kasih
okeh udah di deploy ya
Also available in: Atom
PDF