[Admin] Spreadsheet-style column filtering UI.

[collinanderson]

Code of Conduct

• I agree to follow Django's Code of Conduct

Feature Description

[Admin] Spreadsheet-style column filtering UI for Equals, Contains, Startswith, Greater than, etc.

Problem

By default Django admin allows you to click a column to sort it. It would be nice to also have a simple spreadsheet style filtering UI for Equals, Contains, Startswith, Greater than, etc. Excel and Google Sheets have a UI for this that's worth mimicking for people who are familar with that UI.

Request or proposal

proposal

Additional Details

Excel:

Google Sheets:

Implementation Suggestions

For starters, this would mostly just need to be a UI that builds query parameters that are already supported. ?id__gt=2, text__contains=test, etc. The backend needs to tell the front end what the column type is (numeric vs text), but otherwise this is mostly javascript work.

[github-actions]

Thank you collinanderson for sharing your idea! We have a lot of them so please be patient. You can see the current queue here.

Community instructions

For commenters, please use the emoji reactions on the issue to express support, and/or concern easily. Please use the comments to ask questions or contribute knowledge about the idea. It is unhelpful to post comments of "I'd love this" or "What's the state of this?"

Reaction Guide

• 👍 This is something I would use
• 👎 This is something that would cause problems for me or Django
• 😕 I’m indifferent to this
• 🎉 This is an easy win

[tim-schilling]

I'm not sure this is universally appealing. This may be best suited to being a third-party package / extension for the admin rather than part of the core Django admin.

[nanuxbe]

Hello,

I can see the appeal for such a functionality, django admin already provides filtering, this is an improvement on that.
I see several sub-items for this to happen:

• move the existing admin filters to be part of the column headers instead of in the sidebar (this could be an option)
• maybe there is a need to make the current admin filter more customizable? (ala django-filters)
• While it is tempting to thing this is "just" javacript, I don't think it is. Naive js-only sorting/filtering would work for non-paginated data (although django admin filters provide several filters that would not be trivial to port to js), it would break down when pagination is active

Tip: Assuming my first point would be a good place to start, I would suggest looking at some of the available django admin skins like the ones mentioned in Adam's post to see if one might have already implemented an alternate template with this feature (I really have not idea but it's worth a look)