How do I use filtering in Django?

How do I use filtering in Django?

In Django, you can use the filter() method on a QuerySet to filter results based on specific criteria. For example, MyModel.objects.filter(field_name=value) will return all instances of MyModel where field_name matches the specified value.

Can you give me an example of filtering by multiple fields?

Sure! You can filter by multiple fields by chaining the filter() method. For example: MyModel.objects.filter(field1=value1, field2=value2) will return results that match both conditions.

What if I want to filter using a range of values?

You can use the __range lookup to filter by a range. For example: MyModel.objects.filter(field_name__range=(start_value, end_value)) will return results where field_name is between start_value and end_value.

Is there a way to filter using related models?

Yes! You can filter on related models using the double underscore __ syntax. For example: MyModel.objects.filter(related_model__field_name=value) will filter MyModel instances based on a field in the related model.