Skip to main content

Advanced, modern filtering for Django admin changelists, with saved filters and selectable columns.

Project description

django-admin-superfilter

Advanced, modern filtering for Django admin changelists, with saved filters and selectable columns.

Features

  • Search-bar style filter UI injected into Django admin changelists
  • Type-aware filtering for text, numeric, boolean, choice, date, datetime and relation fields
  • Field path traversal such as author__email
  • Saved filters per authenticated user
  • Column selection and ordering persisted with saved filters
  • AJAX-backed relation picker using Django admin Select2 assets
  • Support for custom filter fields via SuperFilterField
  • Single JSON query parameter for rules (sf) and one for visible columns (sfc)
  • Works without templates overrides

Requirements

  • Python 3.10+
  • Django 4.0+

Installation

Install the package:

pip install django-admin-superfilter

Add the app to INSTALLED_APPS:

INSTALLED_APPS = [
    # ...
    "superfilter",
]

Run migrations:

python manage.py migrate

Quick start

from django.contrib import admin
from superfilter.admin import SuperFilterAdminMixin

from .models import Bird


@admin.register(Bird)
class BirdAdmin(SuperFilterAdminMixin, admin.ModelAdmin):
    list_display = ("species", "location", "count")
    search_fields = ("species",)

Important:

  • Put SuperFilterAdminMixin before admin.ModelAdmin in the MRO.
  • By default, filterable fields come from list_display.
  • Non-model entries in list_display are ignored.
  • Traversed model fields like location__city__name are supported.

What appears in the UI

The package adds a search-bar-like control above the changelist with:

  • an add-filter button
  • filter badges for current rules
  • an Apply button
  • a split menu with Save
  • a Reset button
  • a Columns toggle button
  • a collapsible column chooser
  • saved filter chips

Saved filters store both:

  • the active filter rules
  • the selected column list and order

Supported field kinds and operators

All fields

  • set
  • not_set

Text-like fields

Text-like fields include CharField, TextField, EmailField, SlugField, URLField, UUIDField.

Operators:

  • set
  • not_set
  • eq
  • neq
  • contains
  • not_contains
  • in
  • not_in

Numeric fields

Operators:

  • set
  • not_set
  • eq
  • neq
  • gt
  • lt
  • gte
  • lte

Boolean fields

Operators:

  • set
  • not_set
  • true
  • false

Choice fields

Operators:

  • set
  • not_set
  • in
  • not_in

Foreign key / relation fields

Operators:

  • set
  • not_set
  • in
  • not_in

Date and datetime fields

Operators:

  • set
  • not_set
  • eq
  • before
  • after
  • between

Semantics

  • set means the field is considered populated
  • not_set means the field is empty
  • For text fields, empty means NULL or empty string
  • For boolean fields, set / not_set only target NULL vs non-NULL
  • contains uses icontains
  • not_contains negates icontains
  • between on date/datetime expects exactly two values
  • Relation filters use selected related object primary keys

Configuration

SuperFilterAdminMixin exposes a few attributes:

  • superfilter_param_name = "sf"
  • superfilter_columns_param_name = "sfc"
  • superfilter_fields = None
  • superfilter_page_size = 25
  • superfilter_all_limit = 2000

Example:

class BirdAdmin(SuperFilterAdminMixin, admin.ModelAdmin):
    list_display = ("species", "location", "count")
    superfilter_page_size = 50
    superfilter_all_limit = 5000

Restricting filterable fields

By default, filterable fields are taken from list_display.

To expose a different set of fields, use superfilter_fields:

class BirdAdmin(SuperFilterAdminMixin, admin.ModelAdmin):
    list_display = ("species", "location", "count")
    superfilter_fields = ("species", "count", "location__city")

This only affects filterable fields. Column selection still uses list_display.

Custom filter fields

You can plug in custom fields that do not map directly to a Django model field.

Create a subclass of SuperFilterField:

from django.db.models import Q
from superfilter.logic import SuperFilterField


class HasLargeCountField(SuperFilterField):
    path = "has_large_count"
    label = "Large count"
    kind = "choice"
    choices = [
        {"value": "yes", "label": "Yes"},
        {"value": "no", "label": "No"},
    ]

    def apply_rule(self, queryset, rule):
        values = set(rule.get("value") or [])
        if "yes" in values and "no" not in values:
            return queryset.filter(count__gte=100)
        if "no" in values and "yes" not in values:
            return queryset.filter(count__lt=100)
        return queryset

Register it in superfilter_fields:

class BirdAdmin(SuperFilterAdminMixin, admin.ModelAdmin):
    list_display = ("species", "location", "count")
    superfilter_fields = ("species", HasLargeCountField)

Saved filters

Saved filters are stored in the SavedSuperFilter model and are scoped by:

  • user
  • app label
  • model name
  • saved filter name

Notes:

  • saving requires an authenticated user
  • saved filters are private to the user

URL format

Rules are sent in the sf query parameter as JSON:

[
  {"field": "species", "op": "contains", "value": "owl"},
  {"field": "location", "op": "in", "value": [1, 2]},
  {"field": "count", "op": "gte", "value": 10}
]

Columns are sent in the sfc query parameter as JSON:

["location", "species", "count"]

Relation option loading

For relation filters, the package exposes an admin endpoint that:

  • reuses the related admin's get_search_results() when available
  • otherwise falls back to searching up to three text fields
  • otherwise falls back to PK search for numeric terms

Static assets

The mixin injects:

  • admin/css/vendor/select2/select2.min.css
  • admin/js/vendor/select2/select2.full.min.js
  • superfilter/superfilter.css
  • superfilter/superfilter.js

No custom template override is required.

Limitations

  • Filtering ignores callable/computed list_display entries unless implemented as SuperFilterField
  • Column selection only works on entries present in list_display
  • The package ships with admin-focused frontend assets and is not intended for non-admin pages

Example project

A runnable sample project is available in:

  • examples/sampleapp/

Run it with:

cd examples/sampleapp
python manage.py migrate
python manage.py runserver

Development

Run tests from the repository root:

python manage.py test superfilter

Or use the sample project:

cd examples/sampleapp
python manage.py test

License

MIT. See LICENCE.md.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django_admin_superfilter-0.9.2.tar.gz (29.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

django_admin_superfilter-0.9.2-py3-none-any.whl (32.8 kB view details)

Uploaded Python 3

File details

Details for the file django_admin_superfilter-0.9.2.tar.gz.

File metadata

  • Download URL: django_admin_superfilter-0.9.2.tar.gz
  • Upload date:
  • Size: 29.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/2.4.1 CPython/3.10.14 Windows/10

File hashes

Hashes for django_admin_superfilter-0.9.2.tar.gz
Algorithm Hash digest
SHA256 d7016e21f9b76f5933775a10668b703d8fa75a19fe31cdc3a96ef8a94a35690c
MD5 22425af97058a08bd37eb2d6186af745
BLAKE2b-256 01e6b09be9d9c389285ba2fdd5c3508d42f0a5f318005996815ff34909446c62

See more details on using hashes here.

File details

Details for the file django_admin_superfilter-0.9.2-py3-none-any.whl.

File metadata

File hashes

Hashes for django_admin_superfilter-0.9.2-py3-none-any.whl
Algorithm Hash digest
SHA256 4dab637a3b5e2b08855f331c41ec3b3c8480642edc2f3c7a1bec33642f095f9c
MD5 1301d1fbae0a45d9ae0fe2f29bc0aaf0
BLAKE2b-256 9b2e98fe4d069f5c740d0b9a360665b9091e8b1997f2717aeb2335d99599cacf

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page