A custom method in the model could work fine.
If you set a 'get_latest_by' in the Entry Model ->
http://www.djangoproject.com/documentation/models/get_latest/
Then in the Blog Model define something like:
def last_is_foo(self):
if Entry.objects.latest().title == 'foo'
return True
return False
Adding a CustomManager to that would easily give you back sets.
Getting closer?
On Jun 15, 4:11 pm, Jason <jnorman...@gmail.com> wrote:
> Close. That returns all entrys that have title foo. I need all blogs
> *where the last entry* has title foo. I think I need to
> leverage .extra(where=something) but not having much luck.
>
> On Jun 15, 2:36 pm, Streamweaver <streamwea...@gmail.com> wrote:
>
> > If I understand your question right there is an example that covers
> > this exact situation that may help at
>
> >http://docs.djangoproject.com/en/dev/topics/db/queries/#lookups-that-...
>
> > I believe it could come out to something like this:
>
> > e = Entry.objects.filter(title__exact='foo')
>
> > blog = e.blog
>
> > On Jun 15, 2:41 pm, Jason <jnorman...@gmail.com> wrote:
>
> > > I'm new to django and attempting to leverage the query functionality.
> > > I'm not sure if what I'm attempting requires custom sql or if I"m just
> > > missing something. I'm spending alot of time with the docs but
> > > haven't found guidance for this issue.
>
> > > Just using blogs as an easy example, assume the models below...
>
> > > class Blog(models.Model):
> > > name = models.CharField(max_length=100, unique=True)
>
> > > class Entry(models.Model):
> > > blog = models.ForeignKey(Blog)
> > > title = models.CharField(max_length=100)
>
> > > How can I construct a query that returns all blogs where the last
> > > entry has a title of 'foo'?
>
> > > Note: Using Django 1.1 beta, and thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
