Odoo Help


Customer: Advanced search filter not working?

on 5/15/13, 1:32 PM 3,415 views

In OpenERP V7, the advanced search filter is not working.

For example, if I want to select all customers with "Customer Payment Term is equal to Cash" or "Customer Payment Term contains Cash", the result shown is always the same. The filter is not working at all.

Same effect when trying to filter on a Sale Pricelist. Whatever is filled out in the filter, always all customers are shown.

How to solve this?

What is the datatype of Customer Payment Term? Did you try to use the ID instead of String value?

Bonnet Denis
on 5/16/13, 5:53 AM

Where can I find this, I'm just a user? I only tried the string values which exist / I have added.

on 5/16/13, 5:57 PM

On which object do you try to filter? Customer? AND What is your right access on system? can you connect with admin login?

Bonnet Denis
on 5/21/13, 5:31 AM

Yes, customer. I can set the filter to "Companies", "Contacts" (pre-defined filters), everything o.k. I can fill out a name in the search box (right-top), everything o.k. But searching for above mentioned specific data fails.

on 5/21/13, 11:35 AM

And I can logon as admin, obviously the advanced search should work also for "normal" users.

on 5/21/13, 11:35 AM

It's just to search the id of your search item.

Bonnet Denis
on 5/21/13, 11:43 AM

I can't use the filter. sorry

Bonnet Denis
on 5/21/13, 11:57 AM
On 8/2/13, 10:21 AM


we can implement advance search for sale pricelist by defining a fnct_search .

'property_product_pricelist': fields.property( 'product.pricelist', type='many2one', relation='product.pricelist', domain=[('type','=','sale')], string="Sale Pricelist", view_load=True,fnct_search=_search_prodt_price, help="This pricelist will be used, instead of the default one, for sales to the current partner"),

Like this we can define this function

def _search_prodt_price(self, cr, uid, obj, name, args, context=None):

return must be in the format return [('id','in',[1,3,5])]



I am having a similar problem. When i search Sales Order Category field that contain PC it only returns order up to SO341, where I have many orders after that also contain PC in the category field

on 10/7/13, 7:23 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/15/13, 1:32 PM
Seen: 3415 times
Last updated: 3/16/15, 8:10 AM