Thank you, Carl. I'll try this out.
Carl Meyer wrote:
> On Oct 8, 12:22 am, J <[EMAIL PROTECTED]> wrote:
>
>> How would I include the "date" field from the first model ("Post") in
>> the queryset created from "PostI18N", using something similar to:
>>
>> queryset =
>> PostI18N.objects.filter(lang=get_language()).order_by('post__date')
>>
>> Would that date field already be included? How would I access it from
>> the template?
>>
>
> That query will work fine. In the background it will join the two
> tables for the purposes of filtering your result set, but will not
> select any data from the Post table. You can still do this in your
> template (if post_i18n is a member of the above queryset):
>
> {{ post_i18n.post.date }}
>
> But each time you do that it will generate a new database query to
> look up the Post info.
>
> To avoid the extra queries, you'd use the select_related() method on
> your queryset:
>
> queryset =
> PostI18N.objects.filter(lang=get_language()).order_by('post__date').select_related('post')
>
> This will select all the data from both tables initially, so a single
> query gets you everything you need.
>
> Carl
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
