[Django]-Django queryset filter for blank FileField?

78👍

I was having this issue too, and finally found the solution!

no_files = MyModel.objects.filter(foo='')

This works because internally, the FileField is represented as a local file path in a CharField, and Django stores non-files as an empty string '' in the database.

👤Andrew

7👍

An alternative solution:

no_files = MyModel.objects.filter(foo__in=['',None])
👤MXPLUX

Leave a comment