Maybe I should have titled this how do I create a left join in Django
syntax or with the Django db-API
All the examples in the documentation let you retrieve the related
object ONLY if you have ONE related object retrieved.
On Jul 19, 2:18 pm, Joshua <[EMAIL PROTECTED]> wrote:
> Thank you for your response
>
> I'm not familiar with the context object - I'll have to do some
> research.
>
> I have this working
>
> portfolioPage =
> client.objects.filter(project_portfolio__project_display_bit = True)
>
> It's returning the clients data - just not the data for the
> project_portfolio (it's not joining)?
>
> On Jul 19, 2:08 pm, gkelly <[EMAIL PROTECTED]> wrote:
>
> > I believe in your template you should be able to do something like:
>
> > {% for p in project_portfolio_list %}
> > {{ p.project_name_char }} {{ p.project_client.client_name_char }}
> > {% endfor %}
>
> > If you had a view with:
>
> > context['project_portfolio_list'] = project_portfolio.objects.all()
>
> > You'll also want to be familiar with this portion of the
> > docs:http://www.djangoproject.com/documentation/db-api/#related-objects
>
> > Hope that helps,
> > Grant
>
> > On Jul 19, 11:02 am, Joshua <[EMAIL PROTECTED]> wrote:
>
> > > I've tried to search for a solution to this problem for the last 2
> > > hours and I can't seem to figure it out.
>
> > > I basically want to return a joined table from a queryset - formatted
> > > for my template.
>
> > > I can't seem to figure out how to do this with the Django database
> > > API.
>
> > > With SQL a join query works out to:
>
> > > '''
> > > select project_portfolio.*, client.*
> > > from project_portfolio left join client
> > > on project_portfolio.id = client.id
> > > '''
> > > with the following simplified models:
>
> > > class project_portfolio(models.Model):
> > > project_name_char = models.CharField()
> > > project_client = models.ForeignKey(client)
>
> > > class client(models.Model):
> > > client_name_char = models.CharField
>
> > > The challenge here seems to be that I have to return MULTIPLE
> > > project_portfolio objects and THEN get the "client" data - because NOT
> > > all "clients" have "project_portfolio(s)"
>
> > > Thank you in advance for any help - Josh
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
