(or so it seems)
My model has a class with a reference to itself. It's for modelling a
hierarchy of geographical areas. (e.g. cities in states, states in
countries, countries in continents etc)
class Area(models.Model):
name = models.CharField(max_length=50)
parent = ForeignKey('self', blank=True, null=True)
...
This all works fine.
Now, in the admin interface, a search_field looks for parents matching
a phrase:
search_fields = {'area': (['^parent__name'])}
This also works fine. The (paraphrased) SQL generated is:
SELECT ... FROM `area` INNER JOIN `area` T2 ON (`area`.`parent_id` =
T2.`id`) WHERE (T2.`name` LIKE phrase% )
Super!
Now... I'd like a similar search for *grandparents* matching a phrase:
search_fields = {'area': (['^parent__parent__name'])}
Hm... doesn't seem to work. Only returns those with matching
*parents*. And the SQL is:
SELECT ... FROM `area` INNER JOIN `area` T2 ON (`area`.`parent_id` =
T2.`id`) INNER JOIN `area` T3 ON (`area`.`parent_id` = T3.`id`) WHERE
(T3.`name` LIKE phrase% )
Now I think that second inner join condition should be (T2.`parent_id`
= T3.`id`) because it's the parent of the parent... no?
It seems Django is getting confused because it's querying through the
same model class, but isn't paying attention to recursed instances.
This is Django 1.0.2. Any clues? Is there some (even more) magic query
syntax I should use? Is this a dumb newbie question? ;-)
Many thanks
James
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
