Django admin filter on null date

Question

The filter options on django admin for a date are:

Any date Today Past 7 days This month This year

What is the easiest way to add "None" that filters on blank dates?

Amichai Schreiber · Answer 1 · 2016-05-01T22:23:06.890

1

I just wrote a custom filter for this purpose. It extends Django admin's default DateTimeListFilter and adds "None" and "Not None" options, which do what you think they do.

https://djangosnippets.org/snippets/10566/

You can then go on to use it:

class MyAdmin(ModelAdmin):
    list_filter = (('my_date_field', DateFieldListFilterOrNull),
                  )

edited May 01 '16 at 22:23

answered May 01 '16 at 21:12

Amichai Schreiber

1,528
16
16

This is a fine solution. In 1.11 it's not needed though as the options "Has Date" and "No Date" are already built in. – Aaron McMillin Jun 19 '17 at 21:48

score 0 · Answer 2 · answered Sep 14 '11 at 15:11

0

Think you're looking for the __isnull postfix. For example:

>>> mymodels = MyModel.objects.filter(mydate__isnull=True)
>>> mymodels[0].mydate
(no response)
>>>

answered Sep 14 '11 at 15:11

Chris Pratt

232,153
36
385
444

2

Is there a way of using that in the filters in the admin interface? – PhoebeB Sep 14 '11 at 17:14
Oh, I understand your question now. Sorry, no, there's no way to do that. – Chris Pratt Sep 14 '11 at 17:29

score 0 · Accepted Answer · edited May 23 '17 at 10:28

0

You'll have to register your own filter - look at Custom Filter in Django Admin on Django 1.3 or below or http://twigstechtips.blogspot.com/2010/10/django-create-custom-admin-model-filter.html or lots of other places for how that's done.

Regarding your particular requirement, a snippet for an "IS NULL/IS NOT NULL" filter at http://djangosnippets.org/snippets/1963/

edited May 23 '17 at 10:28

Community

1
1

answered Sep 14 '11 at 23:16

Danny W. Adair

12,498
4
43
49

Snippet just what I needed! Thanks. – PhoebeB Sep 19 '11 at 17:44
Here's something more recent: http://stackoverflow.com/questions/7691890/filtering-django-admin-by-null-is-not-null – Danny W. Adair Oct 07 '11 at 21:31

Django admin filter on null date

3 Answers3