ashiaka ashiaka - 1 year ago 101
Python Question

How can I list all foreign key related objects in Django admin panel?

I would like to implement a very simple feature with the django admin panel but I couldn't find the right way to achieve this so far:

class Author(models.Model):
name = models.CharField()

class Books(models.Model):
title = models.CharField()
author = models.ForeignKey(Author)

class AuthorAdmin(admin.ModelAdmin):
pass, AuthorAdmin)

How can I add a hyperlink to every item (Author) in the authors' list overview that links to a view showing all books of the specific author? For Example:

  • J.K. Rowling (books)

  • J.R.R. Tolkien (books)

where books is a hyperlink to a site showing all books of the author.

Answer Source

You are looking for a ModelAdmin.list_filter.

Set list_filter to activate filters in the right sidebar of the change list page of the admin. A listfilter can be a field name, where the specified field should be either a BooleanField, CharField, DateField, DateTimeField, IntegerField, ForeignKey or ManyToManyField, for example:

 # Add a list filter author to BookAdmin.
 # Now you can filter books by author.
 class BookAdmin(ModelAdmin):
    list_filter = ('author', )

Now you can use @Wolph suggestion to add a link in the Author list_display. This link points to the book list filtered by author:

# Add hyperlinks to AuthorAdmin.
# Now you can jump to the book list filtered by autor. 
class AuthorAdmin(admin.ModelAdmin):
    def authors(self):
        return '<a href="/admin/appname/book/?author__id__exact=%d">%s</a>' % (self.author_id,
    authors.allow_tags = True

ALTERNATIVE. To save a click you can also point to the change view of a book directly:

class Books(models.Model):
    title = models.CharField()
    author = models.ForeignKey(Author)

def get_admin_url(self):
    return "/admin/appname/books/%d/"

class BookAdmin(admin.ModelAdmin):
    def authors(self):
        html = ""
        for obj in Books.objects.filter(
            html += '<p><a href="%s">%s</a></p>' %(obj.get_admin_url(), obj.title)
        return html
    authors.allow_tags = True

    list_display = ['title', authors]

Disclaimer: Not tested, but if you fix the typo's it'll work! :)

Note that these links can also be injected at other points in the admin. When you add it to a widget, you can go from change view to change view.