Skip to Content
This question has been flagged
filter
2 Respostes
1465 Vistes
Avatar
langer@lacatho.de

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!

Avatar
Descartar
Avatar
langer@lacatho.de
Autor Best Answer

Thanks

Avatar
Descartar
Avatar
Renata Carrillo
Best 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 linked to stock_picking and then use that field to filter; anymay, you will have to use base automation with Python Code to accomplish this.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers
filter
Avatar
0
de jul. 25
831
Filters in multiple companies Solved
filter
Avatar
Avatar
1
de maig 25
1560
ADD PROPERTIES Solved
filter
Avatar
Avatar
1
de maig 25
1970
Domain filtering
filter
Avatar
1
de març 25
1943
configure your document layout
filter
Avatar
Avatar
1
de febr. 25
1586