How to create a field that shows 1 field from a one to many relation? (like: Vlookup)

Question

Hi,

I want to add a field with Odoo Studio that shows one specific field of one specific line?

Example:
I have a sale order with 5 order lines
One of those order lines has the product type 'BIG'
How can I create a field on the sale order showing the (first) product where product type = 'BIG'?
Odoo version 12.0

Jake Robinson · Accepted Answer

Hi Bas,
While there's a few ways to do this, I find the most readable to be a computed field with something like this:
for rec in self:
line = rec.order_line.filtered(lambda l: l.product_id.product_type == 'big')
if line:
rec['x_studio_first_big_product'] = line[0].product_id
else:
rec['x_studio_first_big_product'] = False This filters the lines down to only those that are of product type big, and if any exist, uses the first ones product. You would need to add a dependency for order_line.produc

Bas Kremer Hovinga · Answer

Thanks for your quick respons!
I'm trying but I'm new to this so probably doing something wrong, what I have:
*Fields*
x_studio_verkooporderregel_vlookup = new studio field where I'm trying to get the first line
x_studio_type_product = product type, atrribute of the (sale) order line
When  x_studio_type_product = 'Zonnepanelen' , it needs to show first record

*Dependency: *
order.line.product_id.x_studio_type_product
*Code:*
for rec in self:
line = rec.sale.order.line.filtered(lambda l: l.produ

Related Posts	Replies	Views
computed fields Solved 12.0	1 Apr 24	1466
running odoo 12 on ubuntu 22.04 OS, python 3.7, postgresql 15.0 12.0	1 Dec 23	2726
Menu item for users and group only Solved 12.0	2 Nov 22	2416
configuration calendrier pour prise d'heur de RDV en ligne 12.0	0 Nov 22	2736
How to create invoice for employee? 12.0	0 Oct 22	1065

This question has been flagged

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