Project

General

Profile

Bug #3671

perbaikan pada report mutasi dimana pada saat di view terjadi error

Added by Muhammad Bintar 13 days ago. Updated 11 days ago.

Status:
QA Test
Priority:
Normal
Start date:
06/18/2025
Due date:
06/23/2025 (8 days late)
% Done:

0%

Estimated time:

Description

dear tim developer mohon supportnya untuk perbaikan pada report mutasi dimana pada saat di view terjadi error

sp nya sp_hr_md_emp_mutasi

DECLARE @EffectiveDate VARCHAR (10) ='20250618'
DECLARE @Position VARCHAR (MAX) =''
DECLARE @YearsFrom INT =''
DECLARE @MonthFrom INT=''
DECLARE @YearsTo INT =''
DECLARE @MonthTo INT=''
DECLARE @user_id VARCHAR (MAX)='all'

di query error

referensi redmine http://remote.minovais.com:3000/redmine/issues/3522

remote.minovais.com:31139
database
remote.minovais.com, 1458
MinovaHR Bank Mega Development


Files

clipboard-202506181501-59n9b.png (62.3 KB) clipboard-202506181501-59n9b.png Muhammad Bintar, 06/18/2025 03:01 PM
clipboard-202506181502-o1xkh.png (79.9 KB) clipboard-202506181502-o1xkh.png Muhammad Bintar, 06/18/2025 03:02 PM
GetOrgInOrgWide_20250620.sql (2.5 KB) GetOrgInOrgWide_20250620.sql Tri Rizqiaty, 06/20/2025 04:03 PM
GetOrgInOrgWideDetail_20250620.sql (20.6 KB) GetOrgInOrgWideDetail_20250620.sql Tri Rizqiaty, 06/20/2025 04:03 PM
#1

Updated by Kezia Pawitra Yulianti 13 days ago

  • Status changed from New to Assigned
  • Assignee changed from Tri Rizqiaty to Muhammad Bintar

dear Bintar & Daud,
ini case muncul di prod mereka atau kondisi dsini saat kita mau ngetest sesuatu ya di port dev kita?
Untuk checking dan fixing ini sblmd lakukan, kita estimasi dl mandaysnya yaa buat nanti memotong kuota mandays mereka jadi baiknya ini di follow up oleh Rachman dulu

Tks

#2

Updated by Muhammad Bintar 13 days ago

  • Assignee changed from Muhammad Bintar to Kezia Pawitra Yulianti

ini CR yang terkait dengan penambahan org group. salah satu impact nya ke report mutasi. jadi pas di tes di port development bank mega sana, tidak keluar data nya

#3

Updated by Muhammad Bintar 12 days ago

  • Assignee changed from Kezia Pawitra Yulianti to Tri Rizqiaty
#4

Updated by Tri Rizqiaty 11 days ago

Fixing :

Update Function: GetOrgInOrgWide.sql & GetOrgInOrgWideDetail.sql (terlampir)

#5

Updated by Tri Rizqiaty 11 days ago

  • Status changed from Developing to QA Test
  • Assignee changed from Tri Rizqiaty to Muhammad Bintar

Also available in: Atom PDF