[Django]-Filter an evaluated QuerySet in Django

by

3👍

✅

There is no direct way of doing this to get a object based on field value from queryset. But you can do one thing is to create a dictionary from queryset and set name as key (must be unique):

my_objects = MyObject.objects.all()
obj_dict = {obj.name: obj for obj in my_objects}
print obj_dict['any_name']

FYI: If you want to just retrieve a single object from table then you can use .get method:

obj = MyObject.objects.get(pk=id)
or
obj = MyObject.objects.get(name='unique_name')
👤Aamir Rind

0👍

Evaluated queryset is a list. There is no indexation of list elements, so looping is required anyway. But evaluated queryset is assumed to be not so huge, max few hundreds of entries so looping is ok. Do not evaluate large querysets.

By the way, similar lists of objects are created by prefetch_related(). There is an implementation of ListQuerySet which supports many filters, ordering and distinct, making possible to run many (not all though) queries for such lists of objects:

https://github.com/Dmitri-Sintsov/django-jinja-knockout/blob/master/django_jinja_knockout/query.py

👤Dmitriy Sintsov

0👍

@aamir-rind’s solution is great, but it only works if name is unique.

If name is not unique, you could, for example, collect the objects in a list:

# map name to list of objects
my_objects_dict = dict()
for obj in my_objects:
    key = obj.name
    if key not in my_objects_dict:
        my_objects_dict[key] = []
    my_objects_dict[key].append(obj)

If my_objects has not been evaluated yet, the loop will evaluate it. If my_objects has already been evaluated, e.g. as in my_objects = list(MyModel.objects.all()), it will not be evaluated again.

👤djvg

Leave a comment