Production Ticket(ST) #8668
Backup & delete product price for Soliz Tree in Datanory trial server
Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
-
Start date:
21/02/2023
Due date:
22/02/2023
% Done:
100%
Estimated time:
Job Remark:
Ticket Logged Date:
21/02/2023
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
21/02/2023
SLA Delivery:
22/02/2023
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
21/02/2023
Resolution:
select * into mst_product_price_kal_20230221 from mst_product_price
select * into product_item_kal_20230221 from product_item
delete mst_product_price where org_id='A000001'
delete product_item where org_id='A000001'
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
Haikal, u can help me backup & delete product price for Soliz Tree in Datanory trial server? i will import another price later
remember backup the product price table before delete yaa
History
#1 Updated by Anonymous over 1 year ago
- Status changed from Assigned To to Support In Progress
select * into mst_product_price_kal_20230221 from mst_product_price
select * into product_item_kal_20230221 from product_item
delete mst_product_price where org_id='A000001'
delete product_item where org_id='A000001'
#2 Updated by Anonymous over 1 year ago
- Status changed from Support In Progress to Ticket Resolved
- % Done changed from 0 to 100
- Actual Initial Response set to 21/02/2023
- Resolution updated (diff)