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
> understand ...
> "Join on field 'ending_temporal_coverage_date' not permitted."
That's correct. The ending_temporal_coverage_date field isn't a relation
to another model. It's just a date. Unfortunately, Daniel's otherwise
excellent initial reply mislead you slightly at the end. Since "__year"
is a comparison operator, just like "__lt", you cannot use both
together.
However, since ending_temporal_coverage_date is a datetime field, you
can create a Python datetime object that represents 1 January in the
max_year (e.g. upper_bound = datetime.datetime(max_year, 1, 1)) and then
compare against that:
ending_temporal_coverage_date__lt = upper_bound
Regards,
Malcolm
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
