Empty recordset if user.active=false

Question

Hi all,
self .env[ 'res.users' ].sudo().search([( 'id' ,  '=' ,  self .user_id.id)]) returns an empty recordset if the user.active and user.partner_id.active are set to false. Is there anyway to retrieve the inactive recordset for the given id (which is still correct?)
Regards,
Matthias

faOtools · Accepted Answer

Hi,
it is because the ORM 'search' method by default adds the condition to work with active records only. It is quite useful, since in the most cases archived documents should not be shown. E.g. when you open the 'customers' menu, you most probably do not want to see archived partners.
To avoid that explicitly add that you search inactive records. In your example:
self.env['res.users'].sudo().search([
('id', '=', self.user_id.id),
"|",
("active", "=", True),
("active", "=", False),
])

Related Posts	Replies	Views
Recurring training employee	1 Oct 24	280
Employee Bank Account Number Solved employee	2 Jul 24	471
hr_employee_public.timesheet_manager_id does not exist employee	1 Oct 23	1607
PROBLEM - BEUG RENCONTRER LORSQUE J'ESSAIE D'OUVRIR UN EMPLOYEE sur la base odoo employee	0 May 23	1039
how to create employee as an user Solved employee	9 Dec 23	31746

This question has been flagged

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