Production Ticket(ST) #11053
NIBOU - Clean Up Master Data in TRIAL to be migrate to production
1) Delete all the nibou data in all customers related table.
2) Delete all nibou data in all products related table.
Root cause: Clean up the data in Trial environment.
None
Description
- @Assyafiq MCC for Nibou live run, plz assist to setup the price code using this list
- And this is the customer price code mapping, help to update the customer price code
History
#1 Updated by Muhammed Assyafiq Bin Ahmad Kamal 7 months ago
- Project changed from Datanory Production to Datanory Trial
- Subject changed from NIBOU - for Nibou live run, plz assist to setup the price code using this list to NIBOU - Clean Up Master Data in TRIAL to be migrate to production
#2 Updated by Rashdan Hussin 7 months ago
- Status changed from Assigned To to Support In Progress
#3 Updated by Rashdan Hussin 7 months ago
- Status changed from Support In Progress to Ticket Resolved
- % Done changed from 0 to 100
- Esclation Time set to 28/02/2024
- Actual Initial Response set to 26/02/2024
- Resolution updated (diff)
--customer tables
select 'customer' as Data,count(1) as count from customer where org_id ='nibou'
union select 'customer branch' as Data,count(1) as count from mst_customer_branch where org_id ='nibou'
union select 'customer address' as Data,count(1) as count from mst_customer_contact_address where org_id ='nibou'
union select 'user to customer rel' as Data,count(1) as count from customer_to_user_relation where org_id ='nibou'
union select 'customer attachment' as Data,count(1) as count from customer_attachment where org_id ='nibou'
select * from customer where org_id = 'nibou'
select * into _customer_20240227 from customer
delete from customer where org_id = 'nibou'
insert into customer
select * from _customer_20240227 where org_id ='nibou'
select * from mst_customer_branch where org_id = 'nibou'
select * into _mst_customer_branch_20240227 from mst_customer_branch
delete from mst_customer_branch where org_id = 'nibou'
insert into mst_customer_branch
select * from _mst_customer_branch_20240227 where org_id ='nibou'
select * from mst_customer_contact_address where org_id = 'nibou'
select * into _mst_customer_contact_address_20240227 from mst_customer_contact_address
delete from mst_customer_contact_address where org_id = 'nibou'
insert into mst_customer_contact_address
select * from _mst_customer_contact_address_20240227 where org_id ='nibou'
select * from customer_to_user_relation where org_id = 'nibou'
select * into _customer_to_user_relation_20240227 from customer_to_user_relation
delete from customer_to_user_relation where org_id = 'nibou'
insert into customer_to_user_relation
select * from _customer_to_user_relation_20240227 where org_id ='nibou'
select * from customer_attachment where org_id = 'nibou'
select * into _customer_attachment_20240227 from customer_attachment
delete from customer_attachment where org_id = 'nibou'
insert into customer_attachment
select * from _customer_attachment_20240227 where org_id ='nibou'
select * from mst_customer_branch where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
delete mst_customer_branch where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
select * from mst_customer_contact_address where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
delete mst_customer_contact_address where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
select * from customer_to_user_relation where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
delete customer_to_user_relation where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
select * from customer_attachment where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
delete customer_attachment where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
select * from customer where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
delete customer where customer_id in
(select customer_id from customer where org_id = 'nibou' and status = 'inactive')
--product tables
select 'product price' as Data,count(1) from mst_product_price where org_id ='nibou'
union select 'price code' as Data,count(1) from mst_price_code where org_id ='nibou'
union select 'list price code' as Data,count(1) from mst_list_price_code where org_id ='nibou'
select * from mst_product_price where org_id = 'nibou'
select * into _mst_product_price_20240227 from mst_product_price
delete from mst_product_price where org_id = 'nibou'
select * from mst_price_code where org_id = 'nibou'
select * into _mst_price_code_20240227 from mst_price_code
delete from mst_price_code where org_id = 'nibou'
select * from mst_list_price_code where org_id = 'nibou'
select * into _mst_list_price_code_20240227 from mst_list_price_code
delete from mst_list_price_code where org_id = 'nibou'