Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

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

Subscribe

Get notified when there's activity on this post

This question has been flagged
developmenttreeviewlimit
5 Replies
46427 Views
Avatar
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

2
Avatar
Discard
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.

Avatar
Ghanshyam Prajapati
Best Answer

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.

3
Avatar
Discard
Alex Malone
Author

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
Author

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
Author

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.

Avatar
Hardik Shah
Best Answer

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.

1
Avatar
Discard
Avatar
kaynis
Best Answer

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.

1
Avatar
Discard
Avatar
Muhammad Ihza Putra Handayani
Best Answer

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



0
Avatar
Discard
Avatar
Ritesh Bambhaniya
Best Answer
limit = "5" default_order="entry_date"


0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Decoration on grouped treeview?
development treeview listview support
Avatar
Avatar
1
Aug 25
2568
How to get the value from a tree view? Odoo 14
development treeview helpme v14
Avatar
Avatar
Avatar
2
Apr 22
3338
How to set the number of records on a tree view inside a form ? Solved
treeview form listview limit
Avatar
Avatar
Avatar
2
Jan 24
15955
How to make all branches for user active automatically after login his account?
development
Avatar
Avatar
Avatar
3
Nov 25
349
MrpBom _skip_bom_line skips line of product that has two multi-choice attribute values when both are selected in Apply to variant
development
Avatar
Avatar
1
Nov 25
294
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now