Sign in
Try it free
  • Apps
    Websites
    Build great user experience
    • Website Builder
    • eCommerce
    • Blogs
    • Forums
    • Slides
    • Live Chat
    Sales
    Boost your success rate
    • Sales
    • CRM
    • Invoicing
    • Point of Sale
      • Shops
      • Restaurants
      • Hardware
    • Subscriptions
    • Sign
    Operations
    It's all about efficiency
    • Accounting
    • Project
    • Human Resources
      • Recruitment
      • Employees
      • Expenses
      • Appraisal
      • Fleet
      • Leaves
    • Inventory
    • Purchase
    • Manufacturing
      • MRP
      • PLM
      • Maintenance
      • Quality
    • Helpdesk
    Productivity Tools
    Great Tools = Happy People
    • Communication
      • Discuss
      • Mailing Lists
      • Notes
    • Timesheet
    • Email Marketing
    • Events
    • Survey
    • Appointments
    • Marketing Automation
    Third party apps | Odoo Studio | Odoo Cloud Platform NEW
  • Tour
  • Pricing
  • Community
  • Docs

Odoo 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 management | MRP | etc.

Take the tour
Help
  • Trending
  • Newest
  • People
  • Tags
  • Badges
Ask a Question
0

AssertionError: Fields in 'groupby' must be regular database-persisted fields (no function or related fields), or function fields with store=True

ErrorTraceback
By
Apoorv Soral
on 11/10/16, 5:26 AM • 540 views

Traceback (most recent call last):

  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 543, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 580, in dispatch result = self._call_function(**self.params) File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 316, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/pchouksey1/workspace/dexciss/core/openerp/service/model.py", line 118, in wrapper return f(dbname, *args, **kwargs) File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 313, in checked_call return self.endpoint(*a, **kw) File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 809, in __call__ return self.method(*args, **kw) File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 409, in response_wrap response = f(*args, **kw) File "/home/pchouksey1/workspace/dexciss/core/addons/web/controllers/main.py", line 944, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/pchouksey1/workspace/dexciss/core/addons/web/controllers/main.py", line 936, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 268, in wrapper return old_api(self, *args, **kwargs) File "/home/pchouksey1/workspace/dexciss/core/openerp/models.py", line 2093, in read_group assert groupby_def and groupby_def._classic_write, "Fields in 'groupby' must be regular database-persisted fields (no function or related fields), or function fields with store=True"AssertionError: Fields in 'groupby' must be regular database-persisted fields (no function or related fields), or function fields with store=True


how to solve this error? 



  • Flag
  • Reply
  • Comment
  • Share
0

Ahmed M.Elmubarak

--Ahmed M.Elmubarak--

http://www.linkedin.com/pub/ahmed-m-elmubarak/59/ba8/a26/en
3313
| 5 3 5
Sudan
--Ahmed M.Elmubarak--


Ahmed M.Elmubarak
On 11/10/16, 7:37 AM

Hi,

In your code you're trying to make a group_by by using functional field or related field. So try to avoid this or add the attribute store=True to this field.


Hope this could helps ...

  • Comment
  • Flag

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

Thanks for your subscription!
1 follower(s)

Stats

Asked: 11/10/16, 5:26 AM
Seen: 540 times
Last updated: 11/16/16, 1:10 AM
Community
  • Github
  • Download
  • Runbot
  • Translations
  • Mailing Lists
  • Forum
Services
  • Odoo Cloud Platform
  • Support
  • Upgrade
  • Find a partner
  • Become a partner
  • Training center
  • Education
  • Security
About us
  • Our company
  • Contact
  • Events
  • Blog
  • Customers
  • Jobs
  • Legal | Privacy
  • English
    • 简体中文
    • Nederlands
    • Français
    • Deutsch
    • Italiano
    • Português (BR)
    • Español

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

Live Webinar on YouTube

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

Watch now