Re: Query over multivalue relationships

2008-10-15 Thread Malcolm Tredinnick
On Wed, 2008-10-15 at 11:11 -0700, Katja L. wrote: > > DataSet.objects.select_related().filter(coverage__geo_temp_coverage__ending_temporal_coverage_date__year__lt=max_year).order_by('dataset_id_nr') > > Thanks a lot :)! > This helps more or less ;), because now I get a Field Error I don't > und

Re: Query over multivalue relationships

2008-10-15 Thread Katja L.
> Hmm, that's weird. Does it work if you remove the select_related()? No, it doesn't ... I've made a workaround like this ... ds = DataSet.objects.select_related().filter(coverage__geo_temp_coverage__ending_temporal_coverage_date__lte=datetime.date(int(max_year), 12,31)).order_by('dataset_id_nr'

Re: Query over multivalue relationships

2008-10-15 Thread Daniel Roseman
On Oct 15, 7:11 pm, "Katja L." <[EMAIL PROTECTED]> wrote: > > DataSet.objects.select_related().filter(coverage__geo_temp_coverage__ending_temporal_coverage_date__year__lt=max_year).order_by('dataset_id_nr') > > Thanks a lot :)! > This helps more or less ;), because now I get a Field Error I don't

Re: Query over multivalue relationships

2008-10-15 Thread Katja L.
> DataSet.objects.select_related().filter(coverage__geo_temp_coverage__ending_temporal_coverage_date__year__lt=max_year).order_by('dataset_id_nr') Thanks a lot :)! This helps more or less ;), because now I get a Field Error I don't understand ... "Join on field 'ending_temporal_coverage_date' not

Re: Query over multivalue relationships

2008-10-15 Thread Daniel Roseman
On Oct 15, 5:32 pm, Katja Loeffler <[EMAIL PROTECTED]> wrote: > Hi, > > I am relatively new to Django and I have a small problem making a query > over the following Models ... > > class GeographicTemporalCoverage(models.Model): >    beginning_temporal_coverage_date = models.DateField() >    ending