Django: Elegant way to lookup a non-empty string

Question

I have a model Chair with a blank-able CharField called wood_type.

I want to filter all the chairs with a wood_type which is not ''.

What's an elegant way to do it with Django?

I can think of this:

Chair.objects.filter(~django.db.models.Q(wood_type=''))

Or this:

Chair.objects.filter(wood_type__regex='(.|\n)+')

But they're ugly as hell. Is there a more elegant way?

See http://stackoverflow.com/questions/844556/django-filter-how-do-i-go-about-filtering-for-empty-or-null-names-in-a-querys — Hakan B., Aug 11 '13 at 19:28

Maciej Gol · Accepted Answer · 2013-08-11T19:48:17.670

7

Chair.objects.exclude(wood_type='') should do the trick.

edited Aug 11 '13 at 19:48

answered Aug 11 '13 at 19:26

Maciej Gol

Sorry, used the OP's notation. – Maciej Gol Aug 11 '13 at 19:48
I personally don't like it... But marking as accepted anyway because I guess it's the best way there is in Django, in lieu of a new lookup type. – Ram Rachum Aug 11 '13 at 23:26

score 0 · Answer 2 · answered Aug 11 '13 at 19:42

0

exclude the empty string

Chair.objects.exclude(wood_type='')

answered Aug 11 '13 at 19:42

drabo2005

2 Answers2