Skip to Content
This question has been flagged
one2manysearchview
7 Replies
4841 Views
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
Discard
Avatar
Diego Calzadilla
Author 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
Discard
Diego Calzadilla
Author

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
Discard
Diego Calzadilla
Author

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 Views Activity
one2many fileds search view and group by and filter in v10
one2many searchview v10
Avatar
Avatar
1
Jul 19
4320
Add field inside from One2Many field to the search view
one2many searchview search_view One2many
Avatar
1
Oct 23
805
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
7896
How to configure one2many field inside a form with domain or filter Solved
one2many
Avatar
Avatar
2
Apr 22
2462
How to prevent the search view from capturing the cursor?
searchview
Avatar
0
Sep 21
1388