Check lenght of a other field many2many in domain of a many2one field XML

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
회계
재고 관리
PoS
Project
MRP

All apps

모든 게시물 사용자 배지

태그 (모두 보기)

odoo accounting v14 pos v15

게시판 정보

도움말

Check lenght of a other field many2many in domain of a many2one field XML

domain many2many v10

5 답글

10707 화면

Bastien Bascou

Hello !

I'm trapped here, i know how to check if a field many2many or one2many is empty but now i would like to check if it is a singleton or not (if there is 1 record or not inside of it)

for the structure : my view is based on "label" class which has a many2one field on "template" class and a many2many on "product" class. I would like to show some template based on wether or not the product field is a singleton.

I've tried many things here but i can't find the solution i would like something like :

But len here doesn't work.

I even tried :

<field name="template" domain="[('label.products.ensure_one','=',True)]

But this doesn't work neither.

Thank you all ! :)

Mohammed Amal N

You said you have a many2one and many2many field in class label.

Domain for many2one(in your case for template) is used to check or filter the model which the many2one is refering to.

Bastien Bascou

작성자 베스트 답변

I found a way to solve my problem.

I needed to check the size of products to display only templates that can handle this list. Some can handle only one products and their field "multi" is set to False (or 0).

The domain i used to do this is :

['|',('multi','=',True),'&',('multi','=',False),('multi','=',len_products-1)]

Thank you again for your help ;)

Denis Baranov

Glad to hear!

Denis Baranov

Hi,

I guess, you can't achieve desired behavior just using XML. 'label.products' is not good.
The easiest way is to make a computed field to calculate len and place this new field to a form. E.g.:

in your Model:
@api.multi 
@api.depends('products') 
def _compute_len_products(self): 
  for label in self: 
      label.len_products = len(label.products)
len_products = fields.Integer(compute=_compute_len_products, store=True) 

in XML:
<field name="len_products" invisible="1"/> 
<field name="template" domain="[("len_products",'=',1)]"/>

Bastien Bascou

작성자

Quite simple in fact .. :)

I though it could have been done in XML directly. Thank you !

Bastien Bascou

작성자

It doesn't work :'(

it loads field 'len_products' from template class :

ValueError: Invalid field u'len_products' in leaf "<osv.ExtendedLeaf: (u'len_products', u'<=', 1) on label_template (ctx: )>"

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

지금 바로 가입하여 독점 서비스를 이용해보고 특별한 커뮤니티와 소통하세요!

가입

관련 게시물	답글	화면
Many2many domain works when click search more but wrong values in dropdown domain many2many	0 11월 22	80
[SOLVED] Create rule using many2many - how to? 해결 완료 domain many2many	1 6월 22	7397
Many2many domain not working 해결 완료 domain many2many	1 7월 21	2907
Many2many domain not working 해결 완료 domain many2many	1 7월 21	4390
Filter using domain in a many2many relation view 해결 완료 domain many2many	9 2월 16	49450

신고된 질문입니다

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