openerp-community team mailing list archive

[Gustavo Adrian Marino <gamarino@xxxxxxxxx>]

Kevin:
res.partner name_search has some drawbacks. Among others it will break the
search if you are trying to show the name of a partner assigned to a
company you have restricted access (a nightmare on multicompany setups)
In all relations, access rules are applied to the access to the record, but
you always can see the name of the record (many2one or many2many
relationships). In the case of res.partner, name_search uses the current
user access profile to get the name, and that fails if you have no access.
Additionally, it makes a complex processing in case of contacts of
companies, where record by record parents are accessed on sequential
recursive functions. With 54K partners, it will be noticeable.
A serious rework it is needed.
In V7, you can see name_get function on line 538, at res_partner.py on
server/openerp/addons/base/
Best regards

Gustavo Adrian Marino

Mobile: +54 911 5498 2515

Email: gamarino@xxxxxxxxx

Skype: gustavo.adrian.marino






2014-02-11 18:19 GMT-03:00 Kevin Dennis <kldennis@xxxxxxxxxxxxx>:

> When I attempt to use the search field with the default 'Customers' filter
> under Sales-> Customers, it takes over 15 minutes and no results are
> returned (NOTE: we have 54K customers records). If I use 'Advanced Search'
> under the pull-down menu and select 'Name' the results are immediate. Is
> this expected behavior?
>
> I am using OpenERP v7.0-20140113-182049.
>
> Thanks,
>
> *Kevin Dennis*
> Director of IT
> eTech Parts LLC
> 19937 W 162nd St.
> Olathe, KS 66062
> www.etechparts.com
> (913) 839-1718 Office
> (913) 324-1544 Fax
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>