Skip to Content
This question has been flagged
filter
2 Replies
1127 Views
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
Discard
Avatar
langer@lacatho.de
Author Best Answer

Thanks

Avatar
Discard
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
Discard
Related Posts Replies Views Activity
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers
filter
Avatar
0
Jul 25
111
Filters in multiple companies Solved
filter
Avatar
Avatar
1
May 25
1157
ADD PROPERTIES Solved
filter
Avatar
Avatar
1
May 25
1179
Domain filtering
filter
Avatar
1
Mar 25
1168
configure your document layout
filter
Avatar
Avatar
1
Feb 25
1213