Re: order_by with foreign keys
On Mon, Sep 10, [EMAIL PROTECTED] wrote: > > that helps, thanks very much... > > i got a bit confused by all the tickets concerning this issue. also > the documentation doesn't mention any bugs, well bad luck ;) I didn't mean to blame this on you, it's not easy to find your way through the ticket heap. So, have funski, and asking questions is what this mailing list is for ;-) Michael -- noris network AG - Deutschherrnstraße 15-19 - D-90429 Nürnberg - Tel +49-911-9352-0 - Fax +49-911-9352-100 http://www.noris.de - The IT-Outsourcing Company Vorstand: Ingo Kraupa (Vorsitzender), Joachim Astel, Hansjochen Klenk - Vorsitzender des Aufsichtsrats: Stefan Schnabel - AG Nürnberg HRB 17689 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with foreign keys
On 9/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > that helps, thanks very much... > > i got a bit confused by all the tickets concerning this issue. also > the documentation doesn't mention any bugs, well bad luck ;) fortunately you can add a comment to the documentation, mentioning the bug, and pointing to the ticket with the patch that fixes the bug, right? :-D -- John Lenton ([EMAIL PROTECTED]) -- Random fortune: The trouble with a lot of self-made men is that they worship their creator. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with foreign keys
that helps, thanks very much... i got a bit confused by all the tickets concerning this issue. also the documentation doesn't mention any bugs, well bad luck ;) On 10 Sep., 17:53, Michael Radziej <[EMAIL PROTECTED]> wrote: > On Mon, Sep 10, [EMAIL PROTECTED] wrote: > > > hi guys, > > i noticed there have been questions about this before, but none of > > those threads was helpful. > > > i've got a simple db-request, the result should be ordered by a column > > "thema" in a foreign key table "Thema": > > Test.objects.select_related().order_by("my_app_thema.thema"): > > That's a known bug with a ticket and a patch. I don't remember the ticket > number, but it's probably easy to find, look for "order_by". > > Hope that helps a bit, > > Michael > > -- > noris network AG - Deutschherrnstraße 15-19 - D-90429 Nürnberg - > Tel +49-911-9352-0 - Fax +49-911-9352-100http://www.noris.de- The > IT-Outsourcing Company > > Vorstand: Ingo Kraupa (Vorsitzender), Joachim Astel, Hansjochen Klenk - > Vorsitzender des Aufsichtsrats: Stefan Schnabel - AG Nürnberg HRB 17689 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with foreign keys
On Mon, Sep 10, [EMAIL PROTECTED] wrote: > > hi guys, > i noticed there have been questions about this before, but none of > those threads was helpful. > > i've got a simple db-request, the result should be ordered by a column > "thema" in a foreign key table "Thema": > Test.objects.select_related().order_by("my_app_thema.thema"): That's a known bug with a ticket and a patch. I don't remember the ticket number, but it's probably easy to find, look for "order_by". Hope that helps a bit, Michael -- noris network AG - Deutschherrnstraße 15-19 - D-90429 Nürnberg - Tel +49-911-9352-0 - Fax +49-911-9352-100 http://www.noris.de - The IT-Outsourcing Company Vorstand: Ingo Kraupa (Vorsitzender), Joachim Astel, Hansjochen Klenk - Vorsitzender des Aufsichtsrats: Stefan Schnabel - AG Nürnberg HRB 17689 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
order_by with foreign keys
hi guys, i noticed there have been questions about this before, but none of those threads was helpful. i've got a simple db-request, the result should be ordered by a column "thema" in a foreign key table "Thema": Test.objects.select_related().order_by("my_app_thema.thema"): this produces the following error: Column my_app_thema.thema_id does not exist at character 1105 why is that? clearly i don't want django to look for the column "thema_id", instead i want it to look for "thema", so where did i go wrong? the models for this: class Test(models.Model): title = models.CharField(maxlength=120) thema = models.ForeignKey(Thema) class Thema(models.Model): thema = models.CharField(maxlength=90) any help would be greatly appreciated ;) --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with Foreign Keys
Hmm... the site hangs forever in Apache 2.x when I try this...I've emailed the branch developer to ask if there is a known issue w/ select_related... hopefully I can get it worked out ;) --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with Foreign Keys
I'll give this a shot...I'm actually using the multi-db branch..but hopefully this will work here ;) --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with Foreign Keys
I found this patch which fixes it. I've been using it for a while now: http://code.djangoproject.com/ticket/2210 Honza Král wrote: > this works fine, but if you forget the select_related() it will result > in a cross join which is probably the last thing you want from your > database... > > I was bitten by this when I specified this sort of ordering in the model... > > On 1/13/07, gordyt <[EMAIL PROTECTED]> wrote: > > > > Hi Carole, > > > > There is a workaround for this problem. I am using the latest > > subversion build of django, so I don't know if it works with the last > > official build or not. > > > > Here is an example: > > > > ProductVersion.objects.select_related().order_by("kindledb_product.name","version_number") > > > > Here are the model definitions: > > > > class ProductVersion(models.Model): > > product=models.ForeignKey(Product) > > version_number=models.CharField(maxlength=16) > > availability_date=models.DateField(null=True,blank=True) > > release_notes=models.TextField(blank=True) > > > > class Product(models.Model): > > name=models.CharField(maxlength=128) > > > > > > Note that kindledb_product is the name of the database table that > > stores the information from the Product. > > > > --gordon > > > > > > > > > > > > -- > Honza Král > E-Mail: [EMAIL PROTECTED] > ICQ#: 107471613 > Phone: +420 606 678585 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with Foreign Keys
this works fine, but if you forget the select_related() it will result in a cross join which is probably the last thing you want from your database... I was bitten by this when I specified this sort of ordering in the model... On 1/13/07, gordyt <[EMAIL PROTECTED]> wrote: > > Hi Carole, > > There is a workaround for this problem. I am using the latest > subversion build of django, so I don't know if it works with the last > official build or not. > > Here is an example: > > ProductVersion.objects.select_related().order_by("kindledb_product.name","version_number") > > Here are the model definitions: > > class ProductVersion(models.Model): > product=models.ForeignKey(Product) > version_number=models.CharField(maxlength=16) > availability_date=models.DateField(null=True,blank=True) > release_notes=models.TextField(blank=True) > > class Product(models.Model): > name=models.CharField(maxlength=128) > > > Note that kindledb_product is the name of the database table that > stores the information from the Product. > > --gordon > > > > > -- Honza Král E-Mail: [EMAIL PROTECTED] ICQ#: 107471613 Phone: +420 606 678585 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with Foreign Keys
Hi Carole, There is a workaround for this problem. I am using the latest subversion build of django, so I don't know if it works with the last official build or not. Here is an example: ProductVersion.objects.select_related().order_by("kindledb_product.name","version_number") Here are the model definitions: class ProductVersion(models.Model): product=models.ForeignKey(Product) version_number=models.CharField(maxlength=16) availability_date=models.DateField(null=True,blank=True) release_notes=models.TextField(blank=True) class Product(models.Model): name=models.CharField(maxlength=128) Note that kindledb_product is the name of the database table that stores the information from the Product. --gordon --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: order_by with Foreign Keys
On 1/11/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I've seen a few posts that this was a bug where you cannot specify > order_by with a column from a foreign key ... > order_by(foreignkeytable__foreignkeycolumn) because it says table not > found. > > Does anyone know if there are plans to fix this...or if there is a work > around? There are no specific plans that I am aware of (i.e., no schedule that says 'will be fixed by 25 Jan'). There was talk of a refactoring of query.py that was to address problems like this one, but the developer that was championing this cause (Malcolm) has been absent of late. Obviously, it is a bug, and it would be nice if Django had no bugs, but the core developers have limited time, and we spend it where we think it has the most benefit. If someone were to step up and fix this problem, it would probably find its way into the trunk fairly quickly (assuming it was a complete patch, of good quality, with unit tests, etc). Yours, Russ Magee %-) --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
order_by with Foreign Keys
I've seen a few posts that this was a bug where you cannot specify order_by with a column from a foreign key ... order_by(foreignkeytable__foreignkeycolumn) because it says table not found. Does anyone know if there are plans to fix this...or if there is a work around? I have several resultsets where I have columns from several different tables (related by foreignkeys) and I would like to be able sort on those columns. I had originally just had a javascript function to do it on my table...but now I've added a paginator into the mix...and need to actual order the result set. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---