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

Bài viết liên quan	Trả lời	Lượt xem
How To Set Char Type Field Only Have Number Input ODOO 12 ? 12.0	2 thg 1 25	6431
computed fields Đã xử lý 12.0	1 thg 4 24	2436
running odoo 12 on ubuntu 22.04 OS, python 3.7, postgresql 15.0 12.0	1 thg 12 23	4423
Menu item for users and group only Đã xử lý 12.0	2 thg 11 22	3704
configuration calendrier pour prise d'heur de RDV en ligne 12.0	0 thg 11 22	3555

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!