Project

General

Profile

Bug #1795

[Organization Management] - Import

Added by Fiona Avangeline Jonathan about 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Fiona Avangeline Jonathan
Start date:
11/11/2022
Due date:
% Done:

0%

Estimated time:
Spent time:
2.00 h

Description

Mang Wanto,

Mohon dibantu ketika import OM menggunakan excel, muncul error seperti ini dengan jumlah data 1214. Jika dicoba import dengan 606 data sukses.

Terima kasih.

Port: http://remote.minovais.com:31137/

Files

clipboard-202211111712-tqkbm.png (52.1 KB) clipboard-202211111712-tqkbm.png Fiona Avangeline Jonathan, 11/11/2022 05:12 PM
#1

Updated by Saswanto Tampan about 2 years ago

  • Status changed from Assigned to QA Test
  • Assignee changed from Saswanto Tampan to Fiona Avangeline Jonathan

ini dikarenakan tanggal startdate pada excel tidak sama dengan startdate indukannya, sehingga data tidak tertangkap
query yang terjadi saat ini :
SELECT * FROM (SELECT * FROM PHROM0001 WITH (NOLOCK) WHERE StartDate >= '20221115' AND StartDate <= '99991231') AS tblr WHERE ObjectID = '00000046' AND ObjectClass = 'O'

query usulan
 SELECT * FROM (SELECT * FROM PHROM0001 WITH (NOLOCK) WHERE EndDate >= '20221115' AND StartDate <= '20221115') AS tblr  WHERE ObjectID = '00000046' AND ObjectClass = 'O'
#2

Updated by Fiona Avangeline Jonathan about 2 years ago

  • Status changed from QA Test to Closed

kalau dicoba import dengan start date yang sama dengan induknya, import sukses.

Also available in: Atom PDF