How to filter sale orders with a condition that ALL instead of AT LEAST ONE one2Many field fulfills the requirement?

Question

Hi,
I would like to filter sales orders to get only orders where ALL picking_ids.state = 'done'.
If I use the filter [('picking_ids.state', '=', 'done')] I get all orders where at least one picking_ids.state = done.
What can I do to get orders where ALL picking_ids.state = done?

Sylvain Michel RATSARAFAHATRA · Accepted Answer

Hi,
You can combine the search ORM
method
with the filtered function like the below code:
order_ids = self.env['sale.order'].search([('picking_ids.state', '=', 'done')]).filtered(
lambda x: all(picking_id.state == 'done' for picking_id in x.picking_ids)) Best regards!

This question has been flagged

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