Filtering a date/time field omits results.

[redwyrm]

If the pub_date of an poll is today, then it ought to show up when I click Today or This month, but it isn't. It only shows up when I click Any date, Past 7 days, or This year.

My Poll model:

class Poll(models.Model):
    question = models.CharField(max_length=200)
    pub_date = models.DateTimeField('date published')
    #...

And my PollAdmin model:

class PollAdmin(admin.ModelAdmin):
    fieldsets = [
        (None, {'fields': ['question']}),
        ('Date information', {'fields': ['pub_date'], 'classes': ['collapse']}),
    ]
    inlines = [ChoiceInline]
    list_display = ('question', 'pub_date', 'was_published_today')
    list_filter = ['pub_date']

admin.site.register(Poll, PollAdmin)

Current date is August 10th, 2008...
Screenshot when filtering by "Any date": ​http://i38.tinypic.com/ayzdf.jpg
Screenshot when filtering by "Today": ​http://i33.tinypic.com/2342ut.png

My database backend is SQLite3.

[mattbaker]

When you pass unicode strings to filter(dateyear=x) you end up with 0 results, made a quick hack to filter that iterated through and int()ed the unicode strings and everything works as expected.

Adventuring off to dig further...

[mattbaker]

Wow, sorry for the ugly formatting *sigh*

[Amy Farrell]

_sqlite_extract returns unicode (not integer) in all cases, fixes failing compare

[Amy Farrell]

Found that _sqlite_extract (see patch) was returning an integer for month, causing the filter to fail. This was introduced in ChangeSet 8131, which removed str() around the return value. We added unicode(). No one involved is a regular maintainer, so this needs review.

[James Bennett]

#8416 was closed as a duplicate.

[Malcolm Tredinnick]

(In [8494]) Fixed #8214 -- Added back a stringification that was dropped during [8131].
This restores filtering on dates in the admin, for example. Thanks to akfarrell
and a small team of workers at the Portland Sprint.

[Jacob]

Milestone 1.0 deleted