Create object with specific ID

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
Project
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Create object with specific ID

create id sql increment odooV13

2 الردود

8396 أدوات العرض

Benjamin Cherpas

Hi,

I'd like to use the create() method to create objects with a specific ID in database like :

self.env['res.partner'].create({'id': 450, 'name': 'TEST'})

But, the ID keeps going to increment normally : 1, 2, 3, etc. and doesn't be 450 as I want.

I think it's because there is DEFAULT in database : nextval('res_partner_id_seq'::regclass) but even if I remove it, it still increments as a simple ID.

I don't want to use an SQL request like UPDATE because, in my code, there are SQL errors like 'ID already exists'. It's not possible to process like that.

If anyone can help me.

Thank you so much.

Regards.

Ray Carnes (ray)

أفضل إجابة

You should use a different field.

ID is a field maintained by Odoo and not designed to be updatable.

Benjamin Cherpas

الكاتب

Thanks for your answer ! But I ain't sure I understand the purpose of magic columns and how to use 'em. May you explain me better please? :)

Ray Carnes (ray)

Magic Columns are for Odoo. You need to make your own columns if you want to create with a specific ID. Make your own column and put your information in there. Odoo needs the Magic Columns and you are not supposed to interfere with them.

Benjamin Cherpas

الكاتب

Thank you for helping me!

Abderrahim

Well, you can use this

```

SELECT setval('public."table_name_id_seq"',
(SELECT MAX(id) FROM public.table_name)
);

```

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Project.task ID increment, per minute passed? task id increment	2 ديسمبر 24	1000
Import - 'Create if doesn't exist' تم الحل import create odooV13	1 أكتوبر 21	5461
ORM: Create a record with a psecific id تم الحل create orm id	1 يونيو 19	5578
Odoo Module not appearing تم الحل apps create developer odooV13	2 مايو 21	11396
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 مارس 21	2113

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!