Thanks for your help, again
On Jul 19, 4:10 pm, gkelly <[EMAIL PROTECTED]> wrote:
> The Django db-api handles JOINs for you. It abstracts them into
> "forward", "backward" and "many-to-many" relationships (as documented
> on the page I linked before).
>
> Spend some time on the command line playing with these relationships
> and you'll see how you can navigate around your models through foreign
> keys and such.
>
> Also, if you need quicker answers, join #django on irc.freenode.net
> and paste your models at dpaste.com. There's always really bright,
> helpful people hanging around on there.
>
> Grant
>
> On Jul 19, 1:49 pm, Joshua <[EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
