Filter experts needed: Only show deliveries with one item

Question

Hi everyone,
I’m working with Odoo 17 and would like to create a filter in the delivery orders view to show only records that contain *exactly one order line* (i.e. deliveries with a single product).
So far, I couldn’t find a field like "Move Line Count" or similar to filter by the number of items in the delivery.
Does anyone know if there's a built-in field or workaround via the UI (no coding) to achieve this?
Thanks in advance for your help!

langer@lacatho.de · Answer

Thanks

Renata Carrillo · Answer

Without code, it is a bit difficult to achieve the desired result, because in Odoo, when filtering a One2many field with move_line_ids, we cannot directly use the number of records from that table in a simple way, since move_line_ids is a One2many field and the operation of counting rows/IDs is not directly supported in a domain in this manner.
In my perception, what you can do is create an auxiliary field with Odoo Studio to store the number of lines you will have within the move_line_ids linke

Powiązane posty	Odpowiedzi	Widoki
Simultaneous search criteria across companies and persons filter	1 sie 25	56
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers filter	0 lip 25	890
Filters in multiple companies Rozwiązane filter	1 maj 25	1634
ADD PROPERTIES Rozwiązane filter	1 maj 25	2762
Domain filtering filter	1 mar 25	2700

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!