I have a filter that will make me search all fields of the res.partner model (including custom ones) but there's a strange problem. I have around 10 000 "partners" and, no matter what i write (even random characters) in the search field, the filter will always find exactly 8360 matches.
That is simply not possible and the problem started occuring only 3 days ago.
I'm using odoo v11
Here's the filter:
<field name="name" string="Tutto" filter_domain="['|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|','|',
('x_custom_prifor','ilike',self),
('x_custom_ragsoc','ilike',self),
('x_custom_ragso2','ilike',self),
('x_custom_indiri','ilike',self),
('x_custom_capcit','ilike',self),
('x_custom_contoa','ilike',self),
('x_custom_codabi','ilike',self),
('x_custom_codage','ilike',self), ('x_custom_codspo','ilike',self),
('x_custom_codpag','ilike',self),
('x_custom_codfis','ilike',self),
('x_custom_pariva','ilike',self),
('x_custom_claiva','ilike',self),
('x_custom_numtel','ilike',self),
('x_custom_numte2','ilike',self),
('x_custom_numfax','ilike',self),
('x_custom_codpor','ilike',self),
('x_custom_codmez','ilike',self),
('x_custom_codimb','ilike',self),
('x_custom_codasp','ilike',self),
('x_custom_codtra','ilike',self),
('x_custom_codvet','ilike',self),
('x_custom_settor','ilike',self),
('x_custom_annota','ilike',self),
('x_custom_nomen1','ilike',self),
('x_custom_nomen2','ilike',self),
('x_custom_nomen3','ilike',self),
('x_custom_nomen4','ilike',self),
('x_custom_numte3','ilike',self),
('x_custom_numte4','ilike',self),
('x_custom_numfa2','ilike',self),
('x_custom_codsco','ilike',self),
('x_custom_dessco','ilike',self),
('x_custom_scont1','ilike',self),
('x_custom_scont2','ilike',self),
('x_custom_scont3','ilike',self),
('x_custom_scont4','ilike',self),
('x_custom_indir2','ilike',self),
('x_custom_capci2','ilike',self),
('x_custom_ragso3','ilike',self),
('x_custom_cfcoge','ilike',self),
('x_custom_codval','ilike',self),
('x_custom_codiva','ilike',self),
('x_custom_capcap','ilike',self),
('x_custom_capca2','ilike',self),
('x_custom_parcon','ilike',self),
('x_custom_codlis','ilike',self),
('x_custom_codrec','ilike',self),
('x_custom_coddes','ilike',self),
('x_custom_coemai','ilike',self),
('x_custom_coelai','ilike',self),
('x_custom_coegma','ilike',self),
('x_custom_coeglo','ilike',self),
('x_custom_coegli','ilike',self),
('x_custom_coegtr','ilike',self),
('x_custom_cumeff','ilike',self),
('x_custom_emaill','ilike',self),
('x_custom_syssct','ilike',self),
('x_custom_sessoo','ilike',self),
('x_custom_nazion','ilike',self),
('x_custom_tipcon','ilike',self),
('x_custom_blcee1','ilike',self),
('x_custom_blcee2','ilike',self),
('x_custom_conmov','ilike',self),
('x_custom_ivasos','ilike',self),
('x_custom_codcof','ilike',self),
('x_custom_intent','ilike',self),
('x_custom_provin','ilike',self),
('x_custom_descri','ilike',self),
('x_custom_riferi','ilike',self),
('x_custom_codaff','ilike',self),
('x_custom_codmac','ilike',self),
('x_custom_assins','ilike',self),
('x_custom_metodo','ilike',self),
('x_custom_datval','ilike',self),
('x_custom_datpro','ilike',self),
('x_custom_valore','ilike',self),
('x_custom_rifmac','ilike',self),
('x_custom_coegle','ilike',self),
('x_custom_coegsp','ilike',self),
('x_custom_coelae','ilike',self),
('x_custom_coespe','ilike',self),
('x_custom_homepg','ilike',self),
('x_custom_parco2','ilike',self),
('x_custom_cinnnn','ilike',self),
('x_custom_ibannn','ilike',self),
('x_custom_spsinc','ilike',self),
('x_custom_datcon','ilike',self),
('x_custom_datcnt','ilike',self),
('x_custom_datpxc','ilike',self),
('x_custom_datpxv','ilike',self),
('x_custom_noaffi','ilike',self),
('x_custom_datper','ilike',self),
('x_custom_pubbli','ilike',self),
('x_custom_datped','ilike',self),
('x_custom_pubbld','ilike',self),
('x_custom_affris','ilike',self),
('x_custom_cessat','ilike',self),
('x_custom_prifo2','ilike',self),
('x_custom_ritacf','ilike',self),
('x_custom_atecof','ilike',self),
('x_custom_contra','ilike',self),
('x_custom_dataaa','ilike',self),
('x_custom_path01','ilike',self),
('x_custom_path02','ilike',self),
('x_custom_path03','ilike',self),
('x_custom_noemet','ilike',self),
('x_custom_fdurcc','ilike',self),
('x_custom_produr','ilike',self),
('x_custom_datdur','ilike',self),
('x_custom_durdur','ilike',self),
('x_custom_assin2','ilike',self),
('x_custom_notesp','ilike',self),
('x_custom_datins','ilike',self),
('x_custom_codgru','ilike',self),
('x_custom_abbvet','ilike',self),
('x_custom_codloc','ilike',self),
('x_custom_codtic','ilike',self),
('x_custom_datf24','ilike',self),
('x_custom_durf24','ilike',self),
('x_custom_datcia','ilike',self),
('x_custom_durcia','ilike',self),
('x_custom_datd10','ilike',self),
('x_custom_durd10','ilike',self),
('x_custom_fdocum','ilike',self),
('x_custom_fnodip','ilike',self),
('x_custom_datndi','ilike',self),
('x_custom_durndi','ilike',self),
('x_custom_fatema','ilike',self),
('x_custom_numcia','ilike',self),
('x_custom_numail','ilike',self),
('x_custom_numedl','ilike',self),
('x_custom_potfrm','ilike',self),
('x_custom_numnps','ilike',self),
('x_custom_cumbam','ilike',self),
('x_custom_cumdes','ilike',self),
('x_custom_findes','ilike',self),
('x_custom_codrsc','ilike',self),
('x_custom_datemt','ilike',self),
('x_custom_email2','ilike',self),
('x_custom_swiftc','ilike',self),
('x_custom_fconaz','ilike',self),
('x_custom_contob','ilike',self),
('x_custom_impcli','ilike',self),
('x_custom_blalis','ilike',self),
('x_custom_fcolin','ilike',self),
('x_custom_codzon','ilike',self),
('x_custom_forele','ilike',self),
('x_custom_tipele','ilike',self),
('x_custom_ff2d10','ilike',self),
('x_custom_prodes','ilike',self),
('x_custom_inareg','ilike',self),
('x_custom_inpreg','ilike',self),
('x_custom_cedreg','ilike',self),
('x_custom_frnabi','ilike',self),
('x_custom_email3','ilike',self),
('x_custom_codzoa','ilike',self),
('x_custom_gesfid','ilike',self),
('x_custom_fidooo','ilike',self),
('x_custom_fidore','ilike',self),
('x_custom_fidblk','ilike',self),
('x_custom_datres','ilike',self),
('x_custom_cognom','ilike',self),
('x_custom_nomnom','ilike',self),
('x_custom_coduic','ilike',self),
('x_custom_terzis','ilike',self),
('x_custom_gpspos','ilike',self),
('x_custom_cddepa','ilike',self),
('x_custom_ivaspl','ilike',self),
('x_custom_prialt','ilike',self),
('x_custom_cddep2','ilike',self),
('x_custom_tlgusr','ilike',self),
('x_custom_codper','ilike',self),
('x_custom_codute','ilike',self),
('x_custom_codsta','ilike',self)]"/>
