Production Ticket(ST) #10881
Nibou - update the data for the new users
1) Patch the customer relation of Karfoo same as Justin.
Root cause: Client request to update the data for the new users under the name KARFOO.
None
Description
Dear Afiq,
Based on our conversation moments ago, kindly assists to update the data for the new users under the name KARFOO:
KARFOO shares the same customer as the user JUSTIN, which consists a total of 142 customers.
The details of the New Users are provided below:
Login ID: KARFOO
PW: KARFOO123
Org: Nibou
Env: Trial
Many Thanks,
Best regards,
Louise Lim
History
#1 Updated by Rashdan Hussin 8 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 8 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- SLA Delivery set to 31/01/2024
- Esclation Time set to 31/01/2024
- Actual Initial Response set to 23/01/2024
- Resolution updated (diff)
select * from customer_to_user_relation where user_id ='518d3ace-b940-4079-b981-ea72bdb383dd'
select * into #temp_karfoo from customer_to_user_relation where user_id ='518d3ace-b940-4079-b981-ea72bdb383dd'
select * from #temp_karfoo
select * from member where org_id ='NIBOU' and member_cd ='JUSTIN'
select * into _customer_to_user_relation_20240131 from customer_to_user_relation
select * from member where org_id ='NIBOU'
update #temp_karfoo set user_id = 'ba7de64d9dea4fa39fee490cc732d500',
created_date = getdate(), created_by = 'support', updated_date = GETDATE, updated_by = 'support', customer_to_user_relation_id = newid()
insert into customer_to_user_relation
select * from #temp_karfoo
select * from customer where customer_id = '04378467-4ae2-4433-a2a6-a4c007c9d624'
#3 Updated by Rashdan Hussin 8 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100