#36885: Long verbose names in the admin filter sidebar cause main area to reduce to
unusable width
-----------------------------------+------------------------------------
Reporter: Jacob Walls | Owner: Harsh007
Type: Bug | Status: assigned
Component: contrib.admin | Version: 5.2
Severity: Normal | Resolution:
Keywords: wrap admin filter | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 1
-----------------------------------+------------------------------------
Comment (by Harsh007):
Hi, I’ve started looking into this ticket.
I can reproduce the issue on SQLite: using StringAgg(distinct=True) raises
an exception, even though SQLite’s native GROUP_CONCAT supports DISTINCT
in the form:
GROUP_CONCAT(DISTINCT expr)
This seems to be blocked because SQLite only allows DISTINCT when the
aggregate has a single argument (i.e., DISTINCT cannot be used when a
custom separator is passed).
A possible fix would be to allow StringAgg(distinct=True) on SQLite when
no explicit delimiter is provided, and add a regression test to cover the
supported DISTINCT behavior.
I’ll continue investigating the ORM aggregate SQL generation and will work
on a patch + tests.
--
Ticket URL: <
https://code.djangoproject.com/ticket/36885#comment:5>