Bug #1844
[HR-ASSIGNMENT] template upload assignment tidak mengisi kolom organisasi di master data assignment
0%
Description
dear tim developer mohon supportnya untuk perbaikan pada engine untuk generate organisasi karena pada saat mengupload template assignment tidak mengenerate organisasi sehingga pada employee master data tidak tampil informasi nya.
remote.minovais.com:31122
database sql server 2019
remote.minovais.com, 1458
contoh employeeid nya 00000029
Files
Updated by Kezia Pawitra Yulianti about 2 years ago
- Status changed from New to Assigned
- Priority changed from Normal to High
Updated by Muhammad Bintar about 2 years ago
- Status changed from Assigned to QA Test
- Assignee changed from Saswanto Tampan to Muhammad Bintar
update trigger query:
CREATE TRIGGER [dbo].[SetPA2Organization]
ON [dbo].PHRPA0002
AFTER INSERT,UPDATE
AS
BEGIN
DECLARE @now VARCHAR
SET @now = dbo.fn_formatdatetime(GETDATE, 'yyyymmdd')
update PHRPA0002 set Organization = (
SELECT top(1) RelationshipObject
FROM PHROM0002
WHERE (ObjectID = Position) AND (ObjectClass = 'P') AND (RelationshipClass = 'O') AND StartDate < =@now and EndDate >= @now
)WHERE Organization IS NULL OR Organization ='' OR Organization='-' AND (Position !='-'OR Position!='' OR Position IS NOT NULL)
END
Updated by Muhammad Bintar about 2 years ago
- File clipboard-202212141107-qc59j.png clipboard-202212141107-qc59j.png added
- Status changed from QA Test to Closed
- Assignee changed from Muhammad Bintar to Saswanto Tampan
