Skip to Content
Menu
This question has been flagged
1 Reply
2911 Views

I created a controller to fetch records from students table for logged parent user. 

class Webopeneducat(http.Controller):
    @http.route('/my/child', auth='user', website=True)
    def list_students(self, **kw):
        current_user = http.request.env.context.get('uid')
        students = request.env['op.student'].sudo().search([('parent_ids.user_id', '=', current_user)])
        assignments = request.env['op.assignment'].sudo().search(['student[].student_id', 'in', 'allocation_ids'])
        print("students---", students)
        return http.request.render('web_openeducat.index', {

            'students': students,
            'assignments': assignments
            })

I want to obtain records of only logged user. I can get students info from students model, but i also want assignments info of that students from assignments model. how can i fetch data from multiple models at once?

Avatar
Discard
Best Answer

Hi,

If you have the record set of the student in the students varibale and if you need to fetch the assignment records of this student, you can do it like this,

assignments = request.env['op.assignment'].sudo().search([('student_id', 'in',  students.ids)]) 

Thanks

Avatar
Discard