On 12/3/07, Robin Becker <[EMAIL PROTECTED]> wrote:
>
>
> I have a simple model with a foreign key relation
>
> class A(models.Model):
> id = models.CharField('ABCDEFG', .....)
Do you really have an explicit field named 'id'? Do you also include
primary_key=True over in that '....' part? Otherwise it seems you'd get a
conflict between your explicitly id field and Django's auto-generated one.
class B(models.Model):
> def __str__(self):
> return self.name
>
> class Admin:
> list_display = ('name',)
> list_display_links = ('name',)
> ordering = ('a', 'name')
> search_fields = ('a__id','name')
>
> a = models.ForeignKey(A, num_in_admin=3)
> name = models.CharField(maxlength=255, core=True )
>
> originally I had the search_fields=('a','name') but that failed to search
> at
> all. My boss suggested that the documentation
> 'foreign_key__related_fieldname'
> should be replaced by 'a__id' and that seems to locate some rows, but the
> listing page doesn't display. I looked in vain for some simple examples,
> but
> cannot get this simple behaviour to work. What's the 'right' way to search
> by a
> foreign key?
the 'a__id' syntax is correct. I don't quite understand what "seems to
locate some rows, but the listing page doesn't display." means. How can you
tell what it found if the listing page doesn't display? What displays
instead of the listing page -- an error, a blank page, a
never-finishes-loading page...?
For a simple example from my own models that works for me, I have (from a
legacy database so the names don't quite match what you'd expect for a
Django app):
class Authors(models.Model):
AuthorID = models.AutoField(primary_key=True, db_column='Author ID')
Author = models.CharField(unique=True, maxlength=50)
Pseudonym = models.CharField(maxlength=3, choices=YESNO_CHOICES)
Notes = models.CharField(maxlength=50,blank=True)
class Puzzles(models.Model):
PuzzleID = models.AutoField(primary_key=True, ...)
PublisherID = models.ForeignKey(Publishers, ...)
Date = models.DateField(null = True, blank = True)
AuthorID = models.ForeignKey(Authors, ...)
Title = models.CharField(maxlength=64, blank=True)
....much more stuff...
with "search_fields = ['Title', 'AuthorID__Author']" for Puzzles. That lets
me search on Title and Author's name on the Puzzle admin page.
Karen
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
