Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
6950 มุมมอง
อวตาร
Linton Rooms

I dont know what is the most recommended way to display data from a model (A) in the form of a model (B) [Odoo 11].


So far I've used One2many relations, but in this case I cant (or I dont know how to do it).

I have three models:

class School(models.Model):
_name = 'abby.school'
...

class Agreement(models.Model):
_name = 'abby.agreement'
...
agreement_school = fields.Many2one(comodel_name='abby.school', string='School')
...

class Student(models.Model):
_name = 'abby.student'
...
school = fields.Many2one(comodel_name='abby.school', string='School')
...


Graphically: Agreement > School < Student


I want to display a list of Students in the Agreements form.

 
Could I use an One2many relation? Or a SELECT in any place? (I'm a beginner in Odoo)

Thank you in advance!!

อวตาร
ละทิ้ง
Linton Rooms
ผู้เขียน

--- I want to display all the students (could be one or eleven or zero) who belongs to a school with an agreement ---

อวตาร
Sudhir Arya (ERP Harbor Consulting Services)
คำตอบที่ดีที่สุด

If each student will always have one agreement, then you can use One2many field

class Student(models.Model):
    _name = 'abby.student'

    agreement_id = fields.Many2one('abby.aggrement', 'Agreement')

class Agreement(models.Model):
    _name = 'abby.agreement'

student_ids = fields.One2Many('abby.student', 'agreement_id', string="Students")
If the student can have multiple agreements, then you should use the Many2many field:

class Agreement(models.Model):
    _name = 'abby.agreement'

    student_ids = fields.Many2many('abby.student', string="Students")

Update:

Since you want to display all the students belonging to the school, you should use the auto-compute Many2many field:


 class Agreement(...):

    student_ids = fields.Many2many('abby.student', compute='_compute_students')

    @api.depends('agreement_school')
    def _compute_students(self):
        stud_obj = self.env['abby.student']
        for agreement in self:
            # Search students belongs to the school of the agreement
            stud_ids = stud_obj.search([('school', '=', agreement.agreement_school.id)]).ids
            agreement.student_ids = [(6, 0, stud_ids)]




อวตาร
ละทิ้ง
Linton Rooms
ผู้เขียน

Thanks for answering, Sudhir.

I think that solution does not work because there isnt direct relationship between Student and Agreemet. They both point to School:

Agreement > School < Student

Sudhir Arya (ERP Harbor Consulting Services)

Still, with the m2m field, you can select your students in the agreement. Do you want to auto-select all the students belongs to the school of the agreement?

Linton Rooms
ผู้เขียน

Thanks, Sudhir.

### Still, with the m2m field, you can select your students in the agreement.
### Do you want to auto-select all the students belongs to the school of the agreement?

Yes, I want to display (only display, not add or delete) the students who belong to a school with an agreement.

Using this:
student_ids = fields.Many2many('abby.student', string="Students") (In Agreement)

How can I specify the model School?

Thanks a lot

Sudhir Arya (ERP Harbor Consulting Services)

Please check my updated answer.

Linton Rooms
ผู้เขียน

Thank you a lot, Sudhir, for beeing so patient.
It's working... almost!
No errors, but list is empty.
So, I've write these "prints":
class Agreement(...):

student_ids = fields.Many2many(compute='_compute_students')

@api.depends('agreement_school')
def _compute_students(self):

stud_obj = self.env['abby.student']
print ("FooAAA ---")
for agreement in self:
print ("FooBBB agreement:")
print (agreement)
# Search students belongs to the school of the agreement
stud_ids = stud_obj.search([('school', '=', agreement.agreement_school.id)])
print ("FooCCC stud_ids")
print (stud_ids)
print ("FooEEE stud_ids[0]")
print (stud_ids[0])
agreement.student_ids = [(6, 0, stud_ids)]

When I go to an agreement, I get:
FooAAA ---
FooBBB agreement:
abby.agreement(10,)
FooCCC stud_ids
abby.student(1369, 905)
FooEEE stud_ids[0]
abby.student(1369,)

The list in trace "FooCCC" is OK. These are the correct ids to display... but they are not loaded in the list... any idea?

Thanks again!!

Sudhir Arya (ERP Harbor Consulting Services)

Please update bellow code:
agreement.student_ids = [(6, 0, stud_ids)]

Replace (stud_ids.ids):
agreement.student_ids = [(6, 0, stud_ids.ids)]

Linton Rooms
ผู้เขียน

Hi again, and thanks for keep helping!!

Adding "ids", I get this error:
psycopg2.ProgrammingError: relation "_unknown" does not exist
LINE 1: SELECT "_unknown"."id" as "id" FROM "_unknown" WHERE "_unkno...

Looking for that, I have found two posible causes/solutions. The first one recommends to restart both odoo and postgresql. I did it, but the error continues.
In the second comment, they talk about define relationships between models, but in my case, both models are defined in the same module.

Do you know what the problem could be?
Thanks in advance again!

Sudhir Arya (ERP Harbor Consulting Services)

Sorry, I missed to pass on the object name in the m2m field:

student_ids = fields.Many2many('abby.student', compute='_compute_students')

Linton Rooms
ผู้เขียน

It is working.
Sudhir, thank you very very much for your time and sharing your knowledge.

อวตาร
Cybrosys Techno Solutions Pvt.Ltd
คำตอบที่ดีที่สุด

Hi,

To get the data from modelA to modelB we can use Many2one relation here.For example you need to get the list of students list in agreement form,

ie,

class Agreement(models.Model):
    _name = 'abby.agreement'
        student_list_id = fields.Many2one('abby.student', string="Student list")

Regards

อวตาร
ละทิ้ง
Linton Rooms
ผู้เขียน

Thanks for your answer.

But, if I use a Many2one, I will have a list for choose a student...

I want to display all the students (could be one or eleven or zero) who belongs to a school with an agreement.

Regards