Is there a way to count the number of records in a one2many field?
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
This question has been flagged
2
Replies
15217
Views
use len like..
so = self.pool.get('sale.order').browse(cr, uid, id)
count = len(so.order_line)
hope it helps
edit after comment:
also need to check if there is an object like:
count = so.order_line and len(so.order_line) or 0
I tried this but I get this error: object of type 'bool' has no len()
Try using _constraints.
def _check_batch_limit(self, cursor, user, ids, context=None):
for record in self.browse(cursor, user, ids, context=context):
//limit is set as 18 or 20
if len(record.student_registrations) > record.limit:
return False
return True_constraints = [
(_check_batch_limit, 'Error:Limit reached.', ['student_registrations']),
]
I am sorry for my question... but does this code get the limit value from a field in the form?
This code does not work. Why did you accept the answer?
@Abdullah, No one will provide you exact code changes for your problem. We can only provide how this can be achieved. and VOTE is different from ACCEPT.
yes. I obtained the limit value from "LIMIT" field at FORM view.
Sorry for my previous comments. You were absolutely right from the start. Thanks you Atchuthan.
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
@abdullah What exactly you want to achieve by knowing the count of one2many fields?
I have two classes : (batches) & (batches.registrations) In (batches), I have a one2many field called "student_registrations" pointing to (batches.registrations) and showing the student registrations for this batch. However, I can only register 18 to 20 students as per the capacity of the classroom. I need to know how to limit the number of student registrations per batch in the one2many field once the registrations reach 18 or 20.
Related topic link https://www.odoo.com/forum/help-1/question/how-set-limit-for-number-records-of-x2many-6627 https://www.odoo.com/forum/help-1/question/how-to-limit-the-total-number-values-for-a-one2many-field-49700