Project

General

Profile

Support #1006

Create Query untuk mengeluarkan Data Coaching - all Data 2022

Added by ikawati basri over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Low
Assignee:
ikawati basri
Start date:
03/23/2022
Due date:
03/25/2022
% Done:

0%

Estimated time:
Spent time:
1.00 h

Description

Dear Azid,

Mohon bantuannya untuk membuatkan query untuk menarik data ESS coaching di:

SQL Server : MinovaHR_ESS_CNAF_Production2
Table: core_wf_run_main
bizflow_id: MD_COACH
dt_create: like%2020%

semua Reg Id yang ada di core_wf_run_main, digunakan untuk mendapatkan data coaching di table core_wf_run_biz_data.

Sampai di situ saja, agar dapat mengeluarkan semua data Coaching 2022 dengan status sedang berjalan ESS (belum finish) dan sudah finish.
Terimakasih.

Salam,

ika

#1

Updated by M Azid Wahyudi over 2 years ago

  • Status changed from New to Assigned
  • Assignee changed from M Azid Wahyudi to ikawati basri

dear mba ika berikut ini querynya :

select distinct * from core_wf_run_main main
left join core_wf_run_biz_data data on main.reg_id = data.reg_id
where main.bizflow_id = 'MD_COACH' and LEFT = '2022'

makasih

#2

Updated by ikawati basri over 2 years ago

  • Status changed from Assigned to Closed

Also available in: Atom PDF