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	2683
Contacts module python code odoo12 已解決 contacts res.partner odoo12	1 3月 20	4457
Odoo Mail Sending Limit 已解決 odoo12	2 12月 23	14922
(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

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！