Odoo Help

3

Customer: Advanced search filter not working?

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

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.

Register

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)

Stats

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