Django Querying for multiple specific structures

[becca9835]

I am trying to restart some calculations that have failed, and want to query the database for specific structures. To do this, I need to have multiple correct "answers" to a filter. How do I do this properly? I've attached my example code using "or", but I know this isn't correct

structures = (
    static_results.filter(
        spacegroup=148,
        formula_reduced="CdRhF6" or "CdSnF6" ,
    )
    .all()

[jacksund]

close! You want to use the __in operator. So your query becomes...

structures = static_results.filter(
    spacegroup=148,
    formula_reduced__in=["CdRhF6", "CdSnF6"],
).all()