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

Bài viết liên quan	Trả lời	Lượt xem
Search for warehouse inside products tree view filter product search	1 thg 11 22	2572
Suggestions for global filtering data by company? filter searchview odoo10	1 thg 10 22	4895
Filter sale.line on product categories give all product in sub-categories. filter product categories	1 thg 3 15	5367
[✅ SOLVED] How to extend a XML search filter view and add an additional filter ? Đã xử lý filter searchview xmlview v18	1 thg 5 25	3466
Search Bar Filter Customization filter xml searchview searchbar	0 thg 11 24	1317

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!