Odoo Help


This community 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.


Customer: Advanced search filter not working?

on 5/15/13, 1:32 PM 2,213 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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