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

관련 게시물	답글	화면
How To Set Char Type Field Only Have Number Input ODOO 12 ? 12.0	2 1월 25	7234
computed fields 해결 완료 12.0	1 4월 24	3164
running odoo 12 on ubuntu 22.04 OS, python 3.7, postgresql 15.0 12.0	1 12월 23	5726
Menu item for users and group only 해결 완료 12.0	2 11월 22	4558
configuration calendrier pour prise d'heur de RDV en ligne 12.0	0 11월 22	4256

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!