Opened 17 years ago
Closed 17 years ago
#7277 closed defect (fixed)
[PATCH] Report order by overridden with grouping
| Reported by: | Owned by: | Matthew Good | |
|---|---|---|---|
| Priority: | normal | Milestone: | 0.11 |
| Component: | report system | Version: | 0.11-stable |
| Severity: | normal | Keywords: | |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
An SQL report that has a __group__ column and an order by clause gets re-sorted on __group__. The explicit order by is ignored.
An example of this problem is the 'Active Tickets, Mine first' report from the default set of reports. That report gets re-ordered so that "My Tickets" come last.
The attached patch prevents the re-sorting, unless sort parameters have been passed in the request.
Attachments (1)
Change History (3)
by , 17 years ago
| Attachment: | report-group-order.patch added |
|---|
comment:1 by , 17 years ago
| Milestone: | → 0.11 |
|---|
comment:2 by , 17 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
The fix worked fine for me for the "My Tickets" report, and it looks like it didn't break other reports, so I applied the patch in [7183], thanks!



Looks like this was broken with the fix for #7179.