Project

General

Profile

Bug #1411

Generate User dengan user name menggunakan email

Added by Moch Alinafia about 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
High
Assignee:
Moch Alinafia
Start date:
07/26/2022
Due date:
08/03/2022
% Done:

0%

Estimated time:
Spent time:
11.00 h

Description

dear developer

tolong untuk generate user yg sebelum nya user name menggunakan employee id , di ubah menjadi mengunakan email adress,


User name di ambil dari PHRPA0012 yang communication type nya '03' dan di isikan dengan description nya, jika untuk employeid tersebut tidak ada di PHRPA0012 untuk communication type "03" tidak ada, makatidak usah di tampilkan

query untuk ngubah length

SELECT
'ALTER TABLE [' + Table_Schema+'].['+Table_Name+'] Alter Column ['+Column_Name+'] varchar(250);'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='UserName'

Files

clipboard-202207261655-m0784.png (214 KB) clipboard-202207261655-m0784.png Moch Alinafia, 07/26/2022 04:55 PM
MinovaIS.MinovaES.Implementation.Data.Element.TPI.dll (149 KB) MinovaIS.MinovaES.Implementation.Data.Element.TPI.dll Tri Rizqiaty, 07/28/2022 04:44 PM
clipboard-202207281646-hnlc0.png (53.5 KB) clipboard-202207281646-hnlc0.png Tri Rizqiaty, 07/28/2022 04:46 PM
MinovaIS.MinovaES.Business.Core.dll (42.5 KB) MinovaIS.MinovaES.Business.Core.dll Tri Rizqiaty, 07/28/2022 04:46 PM
clipboard-202207281647-nhesw.png (79.2 KB) clipboard-202207281647-nhesw.png Tri Rizqiaty, 07/28/2022 04:47 PM
PCMEPGENPARAM.xlsx (8.9 KB) PCMEPGENPARAM.xlsx Tri Rizqiaty, 07/28/2022 04:47 PM
clipboard-202207281648-rn0ec.png (59.3 KB) clipboard-202207281648-rn0ec.png Tri Rizqiaty, 07/28/2022 04:48 PM
#2

Updated by Moch Alinafia about 2 years ago

  • Description updated (diff)
#3

Updated by Kezia Pawitra Yulianti about 2 years ago

  • Due date set to 08/03/2022
  • Status changed from New to Assigned
  • Priority changed from Normal to High
#4

Updated by Tri Rizqiaty about 2 years ago

Fixing Load :

1. Update API1-bin : MinovaIS.MinovaES.Implementation.Data.Element.TPI.dll (file terlampir)
2. Update API2-bin : MinovaIS.MinovaES.Implementation.Data.Element.TPI.dll (file terlampir)
3. Update table PCMEPGENPARAM sesuai excel terlampir

4. Update table SDATASOURCE - DataSourceName : SGENERATEUSER menjadi seperti gambar dibawah ini

Fixing Generate:

1. Update API1-bin : MinovaIS.MinovaES.Business.Core.dll (file terlampir)
2. Update API2-bin : MinovaIS.MinovaES.Business.Core.dll (file terlampir)
3. Update table PCMEPAPPCONFIG sesuai excel terlampir

#5

Updated by Tri Rizqiaty about 2 years ago

  • Status changed from Developing to QA Test
  • Assignee changed from Tri Rizqiaty to Moch Alinafia
#6

Updated by Moch Alinafia about 2 years ago

  • Status changed from QA Test to Closed

Also available in: Atom PDF