openerp-india team mailing list archive

[PabloCM <1271105@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Version: nightly build openerp-7.0-20140117-002509

Problem:
res_partner.name_search retrieves results in two steps. First, it gets 8 results running a sql query and then filters these results with additional conditions received through args param (e.g. the domain specified in a field of a view). This leads to missing results when meeting certain conditions, being unable to sell/buy from some clients/suppliers because they won't show up in the SO/PO.

How to reproduce:
1. Create empty DB
2. Install sale and purchase
3. Add the following partners. Those whose name is [X]PARTNER are clients and those with name [X]PARTPART are suppliers. I list them in alphabetical order because that is how the aforementioned sql query sorts them.
APARTNER
BPARTNER
CPARTNER
DPARTNER
DPARTPART
EPARTNER
FPARTNER
GPARTNER
HPARTNER
IPARTPART
I provide a csv to import them.
4. Create a purchase order and type in "PART". It will only show DPARTPART, missing IPARTPART
The sql query returned 8 results (from APARTNER to GPARTNER in the previous list) and then these got filtered by the orm search. The client side only receives 1 result, which is not even enough to trigger the "Search more..." in the m2o widget (needs 8) and makes you unable to buy from IPARTPART

Expected result:
It should show both DPARTPART and IPARTPART

** Affects: openobject-addons
     Importance: Undecided
         Status: New


** Tags: namesearch order partner

** Attachment added: "Test example"
   https://bugs.launchpad.net/bugs/1271105/+attachment/3953380/+files/res.partner.csv

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1271105

Title:
  [7.0] res_partner name_search misses results, unable to buy/sell to
  some partners

Status in OpenERP Addons (modules):
  New

Bug description:
  Version: nightly build openerp-7.0-20140117-002509

  Problem:
  res_partner.name_search retrieves results in two steps. First, it gets 8 results running a sql query and then filters these results with additional conditions received through args param (e.g. the domain specified in a field of a view). This leads to missing results when meeting certain conditions, being unable to sell/buy from some clients/suppliers because they won't show up in the SO/PO.

  How to reproduce:
  1. Create empty DB
  2. Install sale and purchase
  3. Add the following partners. Those whose name is [X]PARTNER are clients and those with name [X]PARTPART are suppliers. I list them in alphabetical order because that is how the aforementioned sql query sorts them.
  APARTNER
  BPARTNER
  CPARTNER
  DPARTNER
  DPARTPART
  EPARTNER
  FPARTNER
  GPARTNER
  HPARTNER
  IPARTPART
  I provide a csv to import them.
  4. Create a purchase order and type in "PART". It will only show DPARTPART, missing IPARTPART
  The sql query returned 8 results (from APARTNER to GPARTNER in the previous list) and then these got filtered by the orm search. The client side only receives 1 result, which is not even enough to trigger the "Search more..." in the m2o widget (needs 8) and makes you unable to buy from IPARTPART

  Expected result:
  It should show both DPARTPART and IPARTPART

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1271105/+subscriptions