Can I safety execute a DELETE query on the "res_partner" table.

Question

I made a mistake when importing a list of 1000 contacts using the import contacts tool. Unfortunately, I forgot to backup my database before importing the contacts.
All entries have the tag "casa" and the value "CASA" for a custom column "x_imi_data_import_identifier".
Is it safe for me to execute the SQL query "DELETE FROM res_partner WHERE x_imi_data_import_identifier=`casa`;"?
If not, what other queries can I execute? Or is there a way to delete contacts based on tags?

Chris TRINGHAM · Accepted Answer

In the List View use the standard filter to display all the records with "CASA" in your field "x_imi_data_import_identifier".
Check this is what you want, then select all the records, and the "Delete" option from the Action menu. ​

Krutarth Buch · Answer

Hello,
Rathar than deleting the contacts, can't you update the value in that field?
"UPDATE res_partner set x_imi_data_import_identifier=`CASA` where x_imi_data_import_identifier=`casa`;"
Thanks,

관련 게시물	답글	화면
customer field removed on res.partner when upgrading from odoo 12 to 14 해결 완료 res.partner odoo12 v14	1 4월 23	2688
Contacts module python code odoo12 해결 완료 contacts res.partner odoo12	1 3월 20	4457
Odoo Mail Sending Limit 해결 완료 odoo12	2 12월 23	14926
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 10월 23	33
Error while importing data in Odoo12: An unknown issue occurred during import (possibly lost connection, data limit exceeded or memory limits exceeded) odoo12	3 10월 23	790

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!