Production Ticket(ST) #12104
OROMEO - 120001 user seem like import double already
Job Remark:
Ticket Logged Date:
26/06/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
26/06/2024
SLA Delivery:
28/06/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
26/06/2024
Resolution:
1) Review and verify all the data from the excel file given.
2) Delete the previous route for 120001.
3) Import new route for her.
Root cause: Update the user route.
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
120001 user seem like import double already
So now her planned call around 30 outlet
History
#1 Updated by Rashdan Hussin 3 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 26/06/2024
- Resolution updated (diff)
select * from member where member_cd = '120001'
select * from mst_route where org_id = 'oromeo' and member_id = '50d6e8e6-86cd-40c3-bc5d-fffa2af50c7c'
and CONVERT >= '2024-06-19' AND CONVERT <= '2024-06-30'
order by date --293
--select * into DMS_Ecosystem_Backup_Table.dbo._mst_route_20240626 from DMS_Ecosystem.dbo.mst_route
--delete from mst_route where org_id = 'oromeo' and member_id = '50d6e8e6-86cd-40c3-bc5d-fffa2af50c7c'
--and CONVERT >= '2024-06-19' AND CONVERT <= '2024-06-30'
#3 Updated by Rashdan Hussin 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100