Why does Product search-view not show all products?

Question

When entering a line on a Sale Order, I click the Search more button and a Product Search view comes up. This search view shows 80 of 160 products. I have about 1200 products loaded into the system. Whatever the logic is that is pulling these 160 items is also effecting default filters applied to that view.

As an example, I set a filter to show all products that have a cost price of 10$ or more which should pull up 502 items, but it only pulls 120 records. If I then un-apply the filter and re-a

Axel Mendoza · Accepted Answer

I solved this using the following js extension:
instance.web.DataSet.include({
name_search: function (name, domain, operator, limit) {
*limit = 0;*
return this._model.call('name_search', {
name: name || '',
args: domain || false,
operator: operator || 'ilike',
context: this._model.context(),
limit: limit || 0
});
},
});

Jae Landers · Answer

After quite a bit of searching and digging around, I found where this is coded in -

addons/web/static/src/js/view_form.js

values.push({

label: _t("Search More..."),

action: function() {

+ dataset.name_search(search_val, self.build_domain(), 'ilike', 160).done(function(data) {

self._search_create_popup("search", data);

});

---------------------

The point which states '160' is the limit of how many items will be pulled up by the Search More window upon initial query. I modified this to be

john5000 · Answer

Since this is somewhat hard to track down, one way to check this type of problem is to see what the underlying SQL query is doing. That is simple to view and will shed light on what filters are being applied.

You just need to turn on the postgres logging to show all SQL statements that are run, then do your actions, and then check the postgres log file to see what SQL was run.

Here is how to enable the logging of SQL statements:

Find your "postgresql.conf" file.  (You can find it by doing the

Vasanth · Answer

Hi,

In Openerp,they set the limit has 80 or 120.you can set the limit in the super method as

res = super(product_product,self).name_search(cr, uid, name, args=args, operator=operator, context=context,* limit=limit*)

Sathors · Answer

You can also refer to this Github issue: https://github.com/odoo/odoo/issues/2235

관련 게시물	답글	화면
Search for warehouse inside products tree view filter product search	1 11월 22	2289
Suggestions for global filtering data by company? filter searchview odoo10	1 10월 22	4479
Filter sale.line on product categories give all product in sub-categories. filter product categories	1 3월 15	5151
[✅ SOLVED] How to extend a XML search filter view and add an additional filter ? 해결 완료 filter searchview xmlview v18	1 5월 25	2335
Search Bar Filter Customization filter xml searchview searchbar	0 11월 24	935

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!