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 нояб. 22	2564
Suggestions for global filtering data by company? filter searchview odoo10	1 окт. 22	4887
Filter sale.line on product categories give all product in sub-categories. filter product categories	1 мар. 15	5357
[✅ SOLVED] How to extend a XML search filter view and add an additional filter ? Решено filter searchview xmlview v18	1 мая 25	3433
Search Bar Filter Customization filter xml searchview searchbar	0 нояб. 24	1306

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!