Bug #1844
[HR-ASSIGNMENT] template upload assignment tidak mengisi kolom organisasi di master data assignment
Added by Muhammad Bintar over 2 years ago.
Updated over 2 years ago.
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
- Status changed from New to Assigned
- Priority changed from Normal to High
- 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
Also available in: Atom
PDF
