Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
13 Risposte
14241 Visualizzazioni

Hi,

Due to some reason I need to run sql insert query for creating order lines.
The challenge is I need to map taxes to each order line but, due to I'm not having each line reference "ID"  before,  I can't perform insert onto many2many relation.

Thanks!

Avatar
Abbandona

Sushma, you know the order id, after that your trying to insert order lines into the particular order.So you can get line ids using order id and already you know the tax id, then tell me what's your problem.

Risposta migliore

Hi,

At least you need record id to map with many2many relation.

Avatar
Abbandona
Risposta migliore

Hello ,

        The id will be automatically created , you dont have to give an id to the record.

        Other than Using Query , You Can Try

        sale_order_line_id = self.env['sale.order.line'].create({
            'order_id':order_id,
            'product_id':product_id,
            'product_uom_qty':quantity,
            'price_unit':unit_price
})

    in this manner give every detailes of the order line and you can create an order line by code

    the line will appear on the order which's id is given as the order_id

Avatar
Abbandona
Autore

Hi,

My question is about creating through sql queries not orm. So i would like to know, identical to mapping many2many using orm [(6,0, ids)], can we perform something with SQL queries.

Thanks.

Risposta migliore

Hi Sushma,

This is how inserts in query

query = """ INSERT INTO {rel} ({id1}, {id2})

                        (SELECT a, b FROM unnest(%s) AS a, unnest(%s) AS b)

                        EXCEPT (SELECT {id1}, {id2} FROM {rel} WHERE {id1} IN %s)

                    """.format(**parts)


Regards,

Avatar
Abbandona
Risposta migliore

Hello, 

Check below link i think it's help you 

https://stackoverflow.com/questions/34362637/sql-many2many-query
Avatar
Abbandona
Risposta migliore

Yes we can insert using query.

many2many have a relational table. so insert into the relational table, it will work

Avatar
Abbandona
Autore

Thanks for reply.

Indeed there is different relation for many2many, but my question is while creating parent record how we run SQL query for many2many without ID.

you mean while creating order lines you have insert into many2many relation table

Autore

Yes something like while create order lines wanted to add taxes for each lines through sql query

do you have the tax_id while create the order line

Autore

Yes oblivious, I guess you're diverting something else, please read my posted question once.

Thanks

so your problem is order line id is not available to link it

Post correlati Risposte Visualizzazioni Attività
1
mar 22
14093
1
lug 21
4042
1
ott 20
4949
1
lug 19
5289
1
feb 18
4267