Hey, You can use https://docs.djangoproject.com/en/dev/ref/models/querysets/#range.
Cheers. On Tue, Sep 3, 2013 at 7:02 PM, Neil Menne <[email protected]> wrote: > Hello, all! > > I'm trying to get a query set that 'covers' a date range. Each object only > contains a single date. For example, given a start date of 8/1/13 and an > end date of 8/30/13, I want to filter my objects such that i get the first > object prior to the start date and all objects up to the end date. > > Example data: If the database contains two objects whose dates are 7/30/13 > and 8/15/13, I would want both of these in my query set. Additionally, if > there was an object with a date of 7/15/13, I would want my filters to > exclude this one as the 7/30/13 object covers the start date. > > I do something like: > > MyModel.objects.filter(date__gte=start_date, > date__lte=end_date).order_by('date'). > > This only gets me those dates who are perfectly within the start and end > date range, so it would return the 8/15/13 object. I can follow it up with > something like: > > MyModel.objects.filter(date__lt=start_date).order_by('-date')[:1] > > This gets me only the 7/30/13 object and excludes the 7/15/13 object as > intended. I can then join the two QuerySets and go on my merry way... > > My question is this: Is there a way to do this in a single query? > > Thanks for your time, > Neil > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-users. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
