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
Contabilidad
Inventario
PoS
Project
MRP

All apps

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Acerca de este foro

Ayuda

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

filter search openerp7

2 Respuestas

5447 Vistas

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

Autor

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

Autor

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.

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse

Publicaciones relacionadas	Respuestas	Vistas
How to do an advanced search of an one2many field? filter one2many search openerp7	0 abr 21	9389
how can i create a filter that uses the "and" condition filter search	2 nov 23	3056
How to save a filter with today value from context Resuelto filter search	7 abr 21	20384
filter with related model field Resuelto filter search	1 oct 20	4804
change search filter Resuelto filter search	2 nov 16	4171

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!