Django queryset filter filefield not empty

Question

I'm trying to filter a queryset, to exclude the one with no file. And I can't get it work, except by numberless iterations.

class Something(models.Model):
    name = models.CharField(max_length=512)
    file = models.FieldField(upload_to="files", null=True, blank=True)

Then, to get the one with a file

 # this give me all objects
 Something.objects.exclude(file__exact='')
 
 # this is a valid solution, but hell, something easier should exist, 
 something_with_files = set()
 for s in Something.objects.all():
    if s.file:
        something_with_files.add(s)

What is the real solution to this?

PS: working on PostGres, I don't know if that can change anything at that point.

Answer 1

Exact is unnecessary here:

Something.objects.exclude(file='')

Answer 2

There are better options, I think:

from django.db.models import Q    

Something.objects.filter(~Q(file__isnull=True))

or

Something.objects.exclude(file__isnull=True)

Answer 3

This worked perfectly for me:

objects = MyModel.objects.exclude(
    Q(file='')|Q(file=None)
)

https://books.agiliq.com/projects/django-orm-cookbook/en/latest/filefield.html