Bug #165
[IMFI] Report Separation
0%
Description
Dear Developer,
mohon bantuannya untuk tuning report Separation Detail, saat ini proses pengeluaran report tersebut sangat lama.
Terlampir SP,
Files
Updated by Andi Saputra about 4 years ago
Updated by Saswanto Tampan almost 4 years ago
- Status changed from Assigned to Revise
- Assignee changed from Saswanto Tampan to Andi Saputra
proses ini walaupun sudah di tun sp nya tidak terlalu menghemat waktu, karna saat membaca data transaksi yangmencapai 900 ribu rows sudah memakan waktu pada bagian
==========================================================================================================
SELECT distinct employee_id ,
wage_type ,
dbo.GetPEN(@landscape, amount) amount_separation
FROM dbo.hr_tr0301
WHERE wage_type IN (
SELECT code
FROM dbo.hr_cu0300
WHERE is_pesangon = 'Y'
AND code NOT IN ( '5100', 'TP' ) )--IN
and pay_period_month=@period_month and pay_period_year=@period_year
==========================================================================================================
solusi potong data hr_tr0301
Updated by Saswanto Tampan over 3 years ago
- File NEWQUERYIMFI.txt NEWQUERYIMFI.txt added
- File 2021-05-19_11-18-54.jpg 2021-05-19_11-18-54.jpg added
- Status changed from Revise to QA Test
Boleh di coba menggunakan query yang baru (NEWQUERYIMFI), TERLAMPIR TIMMING REQUEST BERDASARKAN HASIL TESTING DI DB INTERNAL KITA MENGGUNAKAN query yang baru (NEWQUERYIMFI) 7 MENIT 35 DETIK
Updated by Andi Saputra over 3 years ago
- Status changed from QA Test to Deploy
- Assignee changed from Andi Saputra to Saswanto Tampan
Testing ok, report sudah keluar dan sudah deploy.
Update SP, tq mang
Updated by Saswanto Tampan about 3 years ago
- Status changed from Deploy to QA Test
- Assignee changed from Saswanto Tampan to Muhammad Bintar
Updated by Muhammad Bintar almost 3 years ago
- Status changed from QA Test to Closed
- Assignee changed from Muhammad Bintar to Saswanto Tampan