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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Create object with specific ID

create id sql increment odooV13

2 Vastaukset

9024 Näkymät

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)

Paras vastaus

You should use a different field.

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

Benjamin Cherpas

Tekijä

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

Tekijä

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)
);

```

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Project.task ID increment, per minute passed? task id increment	2 jouluk. 24	1575
Import - 'Create if doesn't exist' Ratkaistu import create odooV13	1 lokak. 21	6228
ORM: Create a record with a psecific id Ratkaistu create orm id	1 kesäk. 19	6091
Odoo Module not appearing Ratkaistu apps create developer odooV13	2 toukok. 21	12459
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 maalisk. 21	2590

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!