Project

General

Profile

Bug #2617

[HR-Report All Employee]report all employee lambat ketika diakses dan timbul error not found

Added by Muhammad Bintar 9 months ago. Updated 5 months ago.

Status:
Closed
Priority:
Normal
Start date:
02/27/2024
Due date:
02/29/2024
% Done:

0%

Estimated time:
Spent time:

Description

dear tim developer mohon supportnya untuk perbaikan pada report all employee dimana pada saat melakukan view report
itu keluar datanya lambat dan bisa lama sekitar 20menitan setelah itu error.


Files

INSERT INTO Resign.txt (189 Bytes) INSERT INTO Resign.txt shofwan shiddiq, 02/27/2024 03:11 PM
Rpt_IMFI_HR_PA_ALL_EMPLOYEE_Service.txt (21.7 KB) Rpt_IMFI_HR_PA_ALL_EMPLOYEE_Service.txt shofwan shiddiq, 02/27/2024 03:11 PM
AfterInsertPHRPA0019AttendanceType.txt (375 Bytes) AfterInsertPHRPA0019AttendanceType.txt shofwan shiddiq, 02/27/2024 03:11 PM
Rpt_IMFI_HR_PA_ALL_EMPLOYEE.txt (22.8 KB) Rpt_IMFI_HR_PA_ALL_EMPLOYEE.txt shofwan shiddiq, 02/27/2024 03:11 PM
INSERT INTO Resign.txt (193 Bytes) INSERT INTO Resign.txt shofwan shiddiq, 02/29/2024 04:20 PM
Rpt_IMFI_HR_PA_ALL_EMPLOYEE_JOB.txt (22.7 KB) Rpt_IMFI_HR_PA_ALL_EMPLOYEE_JOB.txt shofwan shiddiq, 02/29/2024 04:20 PM
clipboard-202402292334-rk0hp.png (232 KB) clipboard-202402292334-rk0hp.png Muhammad Bintar, 02/29/2024 11:34 PM
#1

Updated by shofwan shiddiq 9 months ago

Server: remote.minovais.com,1438\SQLSERVER2012
Database: MinovaHR_Indomobil_Dev

1. CREATE Table fisik = hr_md_emp_resign
2. Masukan data employee resign ke table fisik menggunakan query "INSERT INTO Resign"
3. Buat Service Untuk maintain table fisik apabila ada perubahan data menggunakan query "Rpt_IMFI_HR_PA_ALL_EMPLOYEE_Service" dan "AfterInsertPHRPA0019AttendanceType"
4. update SP All Employee pakai query ="Rpt_IMFI_HR_PA_ALL_EMPLOYEE" (Backup dulu yg existing)

#2

Updated by Kezia Pawitra Yulianti 9 months ago

  • Status changed from New to QA Test
#3

Updated by Muhammad Bintar 9 months ago

  • Status changed from QA Test to Closed
  • Assignee changed from Muhammad Bintar to shofwan shiddiq

okeh sudah dideploy ke client..

#4

Updated by Muhammad Bintar 9 months ago

  • Status changed from Closed to Developing
#5

Updated by shofwan shiddiq 9 months ago

update package

1. Create Procedure Rpt_IMFI_HR_PA_ALL_EMPLOYEE_JOB
2. Job Insert into

#6

Updated by shofwan shiddiq 9 months ago

  • Assignee changed from shofwan shiddiq to Muhammad Bintar
#7

Updated by Muhammad Bintar 9 months ago

okeh sudah di update ke client....
tinggal gimana caranya employee status dikosongkan dan tidak mandatory

#8

Updated by Kezia Pawitra Yulianti 8 months ago

  • Status changed from Developing to QA Test

ini bagaimana statusnya?
pls d update ya redmine nya
Tks

#9

Updated by Muhammad Bintar 5 months ago

  • Status changed from QA Test to Closed
  • Assignee changed from Muhammad Bintar to shofwan shiddiq

Also available in: Atom PDF