[v14] How do I use (0, 0, { values }) to add new values on specific rows?

Question

Hi there,

I'm creating a button that automatically adds some products to sale order lines using
order.update([
(0,0,{'product_id':739,'product_uom_qty':70}),
(0,0,{'product_id':742,'product_uom_qty':3})
]) The code works fine, but the products are always added on the second row of sale order lines
Example: https://ibb.co/KGDF89f [1]

I want the new lines to be added after the last line...
How can I 'control' the place where new lines are added?

[1] https://ibb%5C%5C%5C.co/KGDF89f

Waleed Ali Mohsen · Accepted Answer

This happened because of sequence field as the sale order line order by order_id, sequence, id
The default value of the sequence is 10 so when you create it from code it will be 10 so its always added at the first, what you can do is to get the max sequence from all SO lines and then increase it by one and pass it to your cod:
last_so_line = self.env[' sale.order.line'].search([('order_id', [1] '=', order.id)], order='sequence desc', limit=1)
last_sequence = last_so_line.sequence + 1 if last_so_

Rohil · Answer

Hii,
Have you try with adding inverse field in order line ? if not then try with inverse field this might be solve your problem

This question has been flagged

Enjoying the discussion? Don't just read, join in!