Filter based on NULL Values in SQLAlchemy

NULL values filter on column values can be applied in SQLAlchemy using None keyword in filter query.

from sqlalchemy import or_

        EmployeeModel.status != 'active',
        EmployeeModel.status == None #this is used to check NULL values

In the code snippet, we are checking whether the status of the employee is not active or none. We are getting records based on these conditions. We can also apply and_ operator in place of or_ id we want both the conditions needs to be true.

Was this helpful?