Why my many2many field does not appear in the advanced search filter?

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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Why my many2many field does not appear in the advanced search filter?

filter search openerp7

2 Antwoorden

5471 Weergaven

Juan Formoso Vasco

I've added a new field to the res.partner model. This field dummy is a many2many, related to a customized model named res.partner.link.category. In the tree view of partners, if I click on search and then on advanced search, I can create a new filter, selecting a field from res.partner and setting its value/s.

The problem is that I can't see my new field in the advanced search. There's an existing many2many field in res.partner, named category_id, and I can see this one there, in the advanced search. I need my field to behave like that one.

Can anyone help me, please?

Atchuthan - Technical Consultant, Sodexis Inc

If you need to search using Advanced search, then the field needs to be available in your database. i.e. store=True is a must.

So, add store=True for your related field.

Juan Formoso Vasco

Auteur

Thank you! That's a good point, but I've just found the problem and in my case was the one I'm going to post now.

Juan Formoso Vasco

Auteur

In my case, the problem is that my table res.partner.link.category didn't have a column named name, and it didn't have set the attribute _rec_name, so it was impossible to find anything.

Ivan

Not necessarily. You can still have a name_search method defined to be used to search the records. But I guess, it is not currently available as well.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
How to do an advanced search of an one2many field? filter one2many search openerp7	0 apr. 21	9407
how can i create a filter that uses the "and" condition filter search	2 nov. 23	3077
How to save a filter with today value from context Opgelost filter search	7 apr. 21	20423
filter with related model field Opgelost filter search	1 okt. 20	4818
change search filter Opgelost filter search	2 nov. 16	4185

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!