Odoo Help

Welcome!

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.

3

Customer: Advanced search filter not working?

By
wjn
on 5/15/13, 1:32 PM 2,280 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.

wjn
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.

wjn
on 5/21/13, 11:35 AM

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

wjn
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
3
PARVATHY VIJAYAN P
On 8/2/13, 10:21 AM

Hi,

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])]

Thanks

Parvathy

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

Dale
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)

Stats

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