Query on BooleanFields using string representations of the fields

user_6550314 0
Viewed 22

How can I filter on the boolean fields of a model, given a string representation of the attribute, taken to mean true for that attribute?

As an example, given:

class MealBooking(models.Model):

    breakfast = models.BooleanField()
    lunch = models.BooleanField()
    dinner = models.BooleanField()


meal = "breakfast"

How can I filter on all MealBookings containing True for the field represented by meal?

django-orm django-models django
1 Answers

You can filter with:

MealBooking.objects.filter(**{meal: True})

We thus first create a dictionary. If meal is for example 'breakfast', the dictionary will look like { 'breakfast': True }.

Then we unpack the dictionary to named parameters, by adding two asterisks (**) in front. This thus means that if the dictionary is { 'breakfast': True }, we call .filter(…) with .filter(breakfast=True).

user_675790
Related