Skip to Content
This question has been flagged
one2manysearchview
7 Replies
6090 Zobrazenia
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
Zrušiť
Avatar
Diego Calzadilla
Autor 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
Zrušiť
Diego Calzadilla
Autor

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
Zrušiť
Diego Calzadilla
Autor

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 Replies Zobrazenia Aktivita
one2many fileds search view and group by and filter in v10
one2many searchview v10
Avatar
Avatar
1
júl 19
5446
how pass value to on2many field from parent form via context
one2many
Avatar
Avatar
1
jan 25
2780
Add field inside from One2Many field to the search view
one2many searchview search_view One2many
Avatar
1
okt 23
2764
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
10504
How to configure one2many field inside a form with domain or filter Solved
one2many
Avatar
Avatar
2
apr 22
5336