I have 2 model: Contract & Room. 

In model room I have a selection field to set state for room. 

They are my model:

- Room:

	​
class PmaApartmentRoom(models.Model):    
	​_inherit = "pma.apartment.room"
    contract = fields.One2many("pma.contract", "room", string="Contract")
    state = fields.Selection([
	​	​("available", "Available"),
	​	​("rented", "Rented")],
	​	​string="Status", copy=False, 
	​	​index=True, readonly=True, store=True, tracking=True)


 
class PmaContract(models.Model):    
	​_name = "pma.contract"   
	​_inherit = ["mail.thread", "mail.activity.mixin"]   
	​_description = "Manage contract"
    state = fields.Selection([
	​	​("draft", "Draft"),            
	​	​("to_link", "To link"), 
        	​("active", "Active"),
         ("expired", "Expired"),  
         ("liquidated", "Liquidated")],        
	​	​string="Status", default="draft", copy=False,       
	​	​ index=True, readonly=True, store=True, tracking=True,)
    
	​room = fields.Many2one("pma.apartment.room", string="Room name",        	​	​domain="[('apartment', '=', apartment)]",        	​	​	​	​	​	​ondelete="restrict", store=True, required=True, tracking=True)


State of contract = "active" => state of room = "rented".

State of contract in ["draft", "to_link", "expried", "liquidated"] => state of room = "available"


Please help me ....

Hi,

Use Odoo's domain filter to limit your search results to tenants (lessees) with contracts with the status "active" or "liquidated" but no other statuses. These domain requirements can help you achieve this:

tenants_active_liquidated_contracts = self.env['pma.tenant'].search([
    ('contract_id.state', 'in', ['active', 'liquidated']),
    ('contract_id', '!=', False),
])

# You currently have a list of tenants with active or liquidated contracts.
for tenant in tenants_active_liquidated_contracts:
    print("Tenant Name:", tenant.name)  # Replace 'name' with the actual field you want to display

To find tenants who meet the required criteria, we use the search method on the pma.tenant model. We use a domain filter to check if the contract_id field (One2many) is not empty, meaning the tenant has contracts. The state of the contracts (contract_id.state) is also checked to see if it falls within the category of "active" or "liquidated" statuses. The tenants who have contracts with the stated statuses and who don't have contracts with other statuses will be listed for you. The tenant information can then be accessed by iterating through this recordset as needed

Hope it helps

Hi,

Try like this in order to get tenants which satisfy your condition mentioned above,

tenant_ids = self.env['pma.tenant'].search(['|',('contract_id.state', 'in', ['active', 'liquidated']),
('contract_id', '=',False)])

Thanks