Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

How do I limit the number of results in a tree view?

development treeview limit

5 ตอบกลับ

46442 มุมมอง

Alex Malone

Hi folks,

So, within a form view I have an embedded tree view (one2many field). This embedded view, by default, shows 80 results before it starts paging. As this is an embedded view, the number of results is simply too much to be useful. Ideally, I want to limit the number of results to 10.

Now, I have found how to change the number of results system wide but that is not what I want. I only want to change the number of results on this one single view whilst leaving the other views unaffected. Is this functionality possible? If it is not possible out of the box, has anyone written any code to update the web client to make it possible?

Code in question:

<field name="activitylog" colspan="3" nolabel="1" >
      <tree string="Activity Log Entries">
            <field name="entry_date" />
            <field name="activity_type" />
            <field name="name" />
            <field name="state" />
            <field name="contact_id" />
            <field name="user_id" />
            <button type="object" string="Open Activity" name="button_view_activity" icon="gtk-open" />
       </tree>
</field>

I want that tree view to be limited by results. Many thanks

Praveen Upadhyaya

can you please tell me how you fetch all the 80 records in the tree view..............?

Praveen Upadhyaya

please help me

Xsias

Similar ask here.

Alan Luo

if changed \addons\web\static\src\js\view_list.js, like add 'limit': 18, on odoo 8.0, the all tree views will change to limited number of 18, even you've setup limited number on action view.

I would ask question again: I only want to change the number of results on this one single view whilst leaving the other views unaffected. Is this functionality possible?

Omar OUHARI

Hello,

I have the same issu. did you find a solution.

Thanks to informe me if is there any solution.

Regards.

Ghanshyam Prajapati

คำตอบที่ดีที่สุด

Hi Alex, Try

<field name="limit">150</field>

in your action (XML file).

Try Following,

for example,

<record id="action_your_object_form" model="ir.actions.act_window">
    <field name="name">Your Object Name</field>
    <field name="type">ir.actions.act_window</field>
    <field name="res_model">your.object</field>
    <field name="view_type">form</field>
    <field name="limit">150</field>
    <field name="view_mode">tree,form</field>
</record>

Hope this work for you.

Alex Malone

ผู้เขียน

Thanks for the quick response but I don't think this will work. Like I said in the original question, the tree view in question is embedded, meaning that it is a one2many field within a form and the tree view for that one2many field is defined inline.

Ghanshyam Prajapati

Go to Settings / Customization / Low Level Objects / Window Actions Select the action you want to change, edit and change the field Limit, for the number of record you want to display.

Alex Malone

ผู้เขียน

I've updated the original question to show the code in question. Again, the emphasis here is that this is an embedded tree view, meaning there are no defined actions for it so there is nothing for me to edit.

Ghanshyam Prajapati

If you are using OpenERP v7, then GO to Settings / Technical / Windows Actions. Select the action you want to change, edit and change the field Limit, for the number of record you want to display.

Alex Malone

ผู้เขียน

I am using v7. However, like I've said, there is no action defined for this view! Therefore there is nothing to edit in the settings area. As a test, I edited all window actions where the destination model matched what I wanted, but it didn't change anything. I will keep searching for a proper code solution but I expect I am going to have to hack the web client so that it accepts an additional arguement on one2many fields that sets the limit.

Hardik Shah

Refer the link bugs.launchpad.net/openerp-web/+bug/1310486

I have provided a view_form.js patch.

you can add list_options = '{"limit":10}' as O2M field attribute.

kaynis

A quick fix which shows only 10 items at a time on sales order. Go to settings-->customization-->window actions--> look for the sales order window action and edit/change the Limit from 80 to 10 or to any number you wish to reduce the number of items displayed at a time to. You may have to add this number of items in the .js (C:\Program Files (x86)\OpenERP 6.1-1\server\openerp\addons\web\static\src\js open view_list.js and add to the list bwt line 273 and 278) file of web module as well. That is what I have done to reduce the number of items displayed in tree view of Sales Order. This does not however stop you from creating more that 10 items which i think is what you want. If you locate the window action of module of interest you can apply this same process to it.

Muhammad Ihza Putra Handayani

hi alex, simply add in your tag tree limit="your desire number"
in your case, will be

Ritesh Bambhaniya

limit = "5" default_order="entry_date"

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Decoration on grouped treeview? development treeview listview support	1 ส.ค. 25	2571
How to get the value from a tree view? Odoo 14 development treeview helpme v14	2 เม.ย. 22	3338
How to set the number of records on a tree view inside a form ? แก้ไขแล้ว treeview form listview limit	2 ม.ค. 24	15961
How to make all branches for user active automatically after login his account? development	3 พ.ย. 25	353
MrpBom _skip_bom_line skips line of product that has two multi-choice attribute values when both are selected in Apply to variant development	1 พ.ย. 25	297

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!