Project

General

Profile

Production Ticket(ST) #11314

goldcrest- this inv ady knock off in 3/1/2024, but still showing in mobile, and mobile ref number diff with autocount

Added by Muhammed Azhar Mohamed Maideen 6 months ago. Updated 6 months ago.

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Muhammed Azhar Mohamed Maideen
Start date:
27/03/2024
Due date:
29/03/2024
% Done:

0%

Estimated time:
Spent time:
5.00 h
Job Remark:
Ticket Logged Date:
27/03/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
27/03/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
29/03/2024
Resolution:

based on escalation
the change has been been after integration run, therefore then the update will not reflect.
PAtching has been done
Root use - User operational

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

WhatsApp Image 2024-03-27 at 15.22.45_b6ad2da9.jpg (190 KB) WhatsApp Image 2024-03-27 at 15.22.45_b6ad2da9.jpg Muhammed Azhar Mohamed Maideen, 27/03/2024 06:29 PM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Status changed from Assigned To to Support In Progress
  • Type set to Support Request

select * from txn_invoice_history_header where invoice_no='I298268'

select * from customer where customer_id='6DEC1489AEE54B7BB09C870771F1E027'

select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_header_20240329arif from DMS_Ecosystem.dbo.txn_invoice_history_header where invoice_no='I298268'

select * from txn_invoice_history_header where invoice_no='I298268'
--update txn_invoice_history_header set customer_id='9D9A2A3E81AC41B7B53A90B5AAE5C17B' where invoice_no='I298268'
select * from customer where customer_code='302K/229' --orizainal
select * from customer where customer_code='302M/174' --modify

select * from customer_to_user_relation where customer_id='9D9A2A3E81AC41B7B53A90B5AAE5C17B'

select * from member where member_id in (
select user_id from customer_to_user_relation where customer_id='9D9A2A3E81AC41B7B53A90B5AAE5C17B'
)

#2 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • Actual Initial Response set to 29/03/2024
  • Resolution updated (diff)

select * from txn_invoice_history_header where invoice_no='I298268'

select * from customer where customer_id='6DEC1489AEE54B7BB09C870771F1E027'

select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_header_20240329arif from DMS_Ecosystem.dbo.txn_invoice_history_header where invoice_no='I298268'

select * from txn_invoice_history_header where invoice_no='I298268'
--update txn_invoice_history_header set customer_id='9D9A2A3E81AC41B7B53A90B5AAE5C17B' where invoice_no='I298268'
select * from customer where customer_code='302K/229' --orizainal
select * from customer where customer_code='302M/174' --modify

select * from customer_to_user_relation where customer_id='9D9A2A3E81AC41B7B53A90B5AAE5C17B'

select * from member where member_id in (
select user_id from customer_to_user_relation where customer_id='9D9A2A3E81AC41B7B53A90B5AAE5C17B'
)

Also available in: Atom PDF