id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30726	'week' queryset returns no objects	Andrew Williams	nobody	"Using the 'week' queryset modifier results in no objects being returned, despite there being objects in the database.  Here's a simplified version of the model being used:

{{{
import datetime
import pytz

def timestamp():
    return pytz.utc.localize(datetime.datetime.utcnow())

class ReportConfig(models.Model):
    last_modified = models.DateTimeField(default=timestamp)
}}}

From the shell:

{{{
In [54]: ReportConfig.objects.count()
Out[54]: 853

In [55]: ReportConfig.objects.filter(last_modified__week__gte=0,last_modified__week__lte=53).count()
Out[55]: 0

In [56]: ReportConfig.objects.filter(last_modified__week=34).count()
Out[56]: 0

In [57]: ReportConfig.objects.last().last_modified.isocalendar()[1]
Out[57]: 34
}}}

I'm using Django 2.2.4 and MySQL Server version: 5.7.25-log"	Bug	closed	Database layer (models, ORM)	dev	Normal	needsinfo			Unreviewed	0	0	0	0	0	0