Chrome Extension

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_

dbsession.query(
    EmployeeModel
).filter(
    or_(
        EmployeeModel.status != 'active',
        EmployeeModel.status == None #this is used to check NULL values
    )
).all()
Code faster with devsheet chrome extension and increase productivity as a programmer
search code from your favorite search engine instantly.
Install Now

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.

Search Index Data (The code snippet can also be found with below search text)

NULL check SQLAlchemy
Was this helpful?
0 Comments
Open Code Manager We are hiring