Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
one2manysearchview
7 Odgovori
5704 Prikazi
Avatar
Diego Calzadilla

In product template search view is defined a field to do search by product attributes:

<field string="Product Variant" name="product_variant_ids" filter_domain="['|', ('product_variant_ids.name','ilike',self), ('product_variant_ids.attribute_value_ids.name','ilike',self)]"/>

product_variants_ids is a one2many field in product.template. When I write some attribute value, it brings the correct record, but when I write the atrribute name, it brings nothing, for example, in attribute page for some product I have:

MEMORY   32gb

COLOR      red

If I type 32gb, it brings record, whereas if I type MEMORY, brings nothing

Can any one help me? I would also like to understand filter_domain of this example.


Thanks!!

Avatar
Opusti
Avatar
Diego Calzadilla
Avtor Best Answer


     <field string="Product Variant" name="product_variant_ids" filter_domain="['|', ('product_variant_ids.name','ilike',self), ('product_variant_ids.attribute_value_ids.name','ilike',self), ('product_variant_ids.attribute_value_ids.attribute_id.name','ilike',self)]"/>

Avatar
Opusti
Diego Calzadilla
Avtor

I tried this in order to keep both types of search, but didn't work, any suggestions?

Jérémy Kersten (jke)

You need to add an or ("|") before... |, |, cond1, cond2, cond3

Avatar
Jérémy Kersten (jke)
Best Answer

Hello, It's a bug...

The right domain should be : 

<field string="Product Variant" name="product_variant_ids" filter_domain="['|', ('product_variant_ids.name','ilike',self), ('product_variant_ids.attribute_value_ids.attribute_id.name','ilike',self)]"/>


You can change this one in view directly !

Fix merged in V8 : https://github.com/odoo/odoo/commit/42aa9096d9c1aa54529960e70590335660e33d12 

Avatar
Opusti
Diego Calzadilla
Avtor

Thank you, it works!! However, search by attribute value is lost, I would like to keep both types of search. I tried something like this: And didn't work, any suggestions?

Related Posts Odgovori Prikazi Aktivnost
one2many fileds search view and group by and filter in v10
one2many searchview v10
Avatar
Avatar
1
jul. 19
5051
how pass value to on2many field from parent form via context
one2many
Avatar
Avatar
1
jan. 25
1816
Add field inside from One2Many field to the search view
one2many searchview search_view One2many
Avatar
1
okt. 23
2166
How to make tree view place last entered field on the top of tree view? What is the difference between editable="top" and editable="bottom"?
one2many
Avatar
Avatar
Avatar
2
sep. 22
9542
How to configure one2many field inside a form with domain or filter Solved
one2many
Avatar
Avatar
2
apr. 22
4589